Emerson Lima

Objetivo

Renomear o pluggable database (PDB) de nome PDBWFM para PDBWFM01.

$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue May 5 12:22:30 2020

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBWFM READ WRITE NO

Para a operação de rename, o PDB deve estar no modo RESTRITO:

SQL> alter pluggable database PDBWFM close immediate;
Pluggable database altered.

SQL> alter pluggable database PDBWFM open restricted;
Pluggable database altered.

SQL> select name, open_mode from v$pdbs;

NAME OPEN_MODE RESTRICTED
------------------------------ ---------- ----------
PDB$SEED READ ONLY NO
PDBWFM READ WRITE YES

Executa o rename e reinicia (CLOSE/OPEN) o PDB:

SQL> alter session set container = PDBWFM;
Session altered.

SQL> alter pluggable database PDBWFM rename global_name to PDBWFM01;
Pluggable database altered.

SQL> alter pluggable database PDBWFM01 close immediate;
Pluggable database altered.

SQL> alter pluggable database PDBWFM01 open;
Pluggable database altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBWFM01 READ WRITE NO

Os diretórios correspondentes ao PDB não são renomeados. Se você deseja mover os datafiles para um novo diretório use o recurso “Online Move Datafile” do Oracle 12c.

Para renomear o Oracle Managed-Files (OMF) consulte a documentação disponível na referência desse artigo [1].

Gostaria de acessar este post em inglês? Clique aqui
Would you like to access this post in English? Click here

Referência