SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SEED_PDB MOUNTED
4 NONCDB_PDP MOUNTED
5 CLON_PDB MOUNTED
6 TEST_PDB READ WRITE NO
7 PDB4 READ WRITE NO
SQL> Alter pluggable database pdb4 close;
Pluggable database altered.
SQL> Alter pluggable database pdb4 unplug into '/tmp/pdb4.xml';
Pluggable database altered.
SQL> Drop pluggable database pdb4;
Pluggable database dropped.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SEED_PDB MOUNTED
4 NONCDB_PDP MOUNTED
5 CLON_PDB MOUNTED
6 TEST_PDB READ WRITE NO
[oracle@12cr2 pdb4]$ cd /u01/app/oracle/oradata/zylong/pdb4
[oracle@12cr2 pdb4]$ ll
total 706588
-rw-r----- 1 oracle oinstall 356524032 Jun 4 19:04 sysaux01.dbf
-rw-r----- 1 oracle oinstall 262152192 Jun 4 19:04 system01.dbf
-rw-r----- 1 oracle oinstall 104865792 Jun 4 19:04 undotbs01.dbf
SQL> Create pluggable database pdb4 using '/tmp/pdb4.xml' copy
file_name_convert=('/u01/app/oracle/oradata/zylong','/u01/app/oracle/oradata/zylong/pdb4');
Pluggable database created.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SEED_PDB MOUNTED
4 NONCDB_PDP MOUNTED
5 CLON_PDB MOUNTED
6 TEST_PDB READ WRITE NO
7 PDB4 MOUNTED
SQL> Alter pluggable database pdb4 unplug into '/tmp/pdb4.xml';
Pluggable database altered.
SQL> Drop pluggable database pdb4;
Pluggable database dropped.
SQL> Create pluggable database pdb4 using '/tmp/pdb4.xml' nocopy;
Pluggable database created.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SEED_PDB MOUNTED
4 NONCDB_PDP MOUNTED
5 CLON_PDB MOUNTED
6 TEST_PDB READ WRITE NO
8 PDB4 MOUNTED
SQL> Alter pluggable database pdb4 unplug into '/tmp/pdb4.xml';
Pluggable database altered.
SQL> Drop pluggable database pdb4;
Pluggable database dropped.
SQL> CREATE PLUGGABLE DATABASE pdb4 AS CLONE USING '/tmp/pdb4.xml' NOCOPY TEMPFILE REUSE;
Pluggable database created.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SEED_PDB MOUNTED
4 NONCDB_PDP MOUNTED
5 CLON_PDB MOUNTED
6 TEST_PDB READ WRITE NO
7 PDB4 MOUNTED