How to detach (unplug) an PDB database
sqlplus / as sysdba
alter pluggable database pdb1 close immediate;
alter pluggable database pdb1 unplug into '/u01/app/oracle/oradata/pdb1.xml';
drop pluggable database pdb1 keep datafiles;
show pdbs
How to attach (plugin) a PDB database
sqlplus / as sysdba
set serveroutput on
DECLARE
compatible BOOLEAN := FALSE;
BEGIN
compatible := DBMS_PDB.CHECK_PLUG_COMPATIBILITY(
pdb_descr_file => '/u01/app/oracle/oradata/pdb1.xml');
if compatible then
DBMS_OUTPUT.PUT_LINE('Is PDB compatible? YES');
else DBMS_OUTPUT.PUT_LINE('Is PDB compatible? NO');
end if;
END;
/
Attach PDB with NOCOPY
create pluggable database pdb_new using '/u01/app/oracle/oradata/pdb1.xml'
NOCOPY
TEMPFILE REUSE;
Attach PDB with COPY
$ mkdir -p /u01/app/oracle/oradata/cdbnew/pdb_new
$ sqlplus / as sysdba
create pluggable database pdb_new using '/u01/app/oracle/oradata/pdb1.xml'
COPY
FILE_NAME_CONVERT('/u01/app/oracle/oradata/cdb/pdb1','/u01/app/oracle/oradata/cdbnew/pdb_new');