Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unplug and plug the PDB with a different name

flying_penguinMay 30 2022

DB version: 19c 
OS: Oracle Linux 7.9

In my Linux DB server, I have a pluggable database PDB_SALES_ME hosted in container database CDB_AUX.
In the same DB server, I have another container database named CDB_D6.

Both CDBs use the same ASM filesystem (Oracle Restart) configured in the server.

Is it possible for me to unplug PDB_SALES_ME from CDB_AUX and plug it into CDB_D6 as PDB_SALES_ME_DEV ?

i.e., Is the below possible ?

---- Unplug
--- Connected to CDB_AUX's CDB$ROOT using sysdba privilege

alter pluggable database PDB_SALES_ME close;
alter pluggable database PDB_SALES_ME unplug into '/a_path/in/linux/PDB_SALES_ME.xml';
drop pluggable database PDB_SALES_ME keep datafiles;

--- Plug 
--- Connected to CDB_D6's CDB$ROOT using sysdba privilege

create pluggable database PDB_SALES_ME_DEV 
using '/a_path/in/linux/PDB_SALES_ME.xml'
tempfile reuse 
nocopy;
Comments
Post Details
Added on May 30 2022
1 comment
839 views