SQL> show pdbs;

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

SQL> alter pluggable database all close;

Pluggable database altered.

SQL> alter pluggable database pdb01 unplug into '/home/oracle/pdb01.pdb';

Pluggable database altered.

SQL> !ls -l /home/oracle
total 111172
-rw-r--r-- 1 oracle oinstall 113839809 Sep  5 09:08 pdb01.pdb

SQL> !unzip -t pdb01.pdb
Archive:  pdb01.pdb
    testing: system01.dbf             OK
    testing: sysaux01.dbf             OK
    testing: undotbs01.dbf            OK
    testing: users01.dbf              OK
    testing: /home/oracle/pdb01.xml   OK
No errors detected in compressed data of pdb01.pdb.

SQL> create pluggable database pdb02 as clone using '/home/oracle/pdb01.pdb' file_name_convert=('/home/oracle/','/oradata/orcl/pdb02') ;

Pluggable database created.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB01                          MOUNTED
         4 PDB02                          MOUNTED

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle