DBA Hub

📋Steps in this guide1/1

Rename A Pluggable Database ( PDB)

In this blog , we will see how to Rename A Pluggable Database ( PDB) ?

oracle configurationintermediate
by OracleDba
12 views
1

Overview

In this blog , we will see how to Rename A Pluggable Database ( PDB) ? - Start Pluggable Database with restrict mode :

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
SQL> alter session set container=pdbtest;

Session altered.

SQL>
SQL>  shutdown immediate;
Pluggable Database closed.
SQL> startup open restrict
Pluggable Database opened.

SQL> alter pluggable database pdbtest rename global_name to pdbdb;

Pluggable database altered.

SQL>
SQL> show con_name;

CON_NAME
------------------------------
PDBDB
SQL>

SQL> shutdown immediate;
Pluggable Database closed.
SQL>
SQL>
SQL> startup
Pluggable Database opened.

SQL> alter session set container=CDB$ROOT;

Session altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDBDB                          READ WRITE NO
         4 ABC                            READ WRITE NO
SQL>

Comments (0)

Please to add comments

No comments yet. Be the first to comment!