Shulou(Shulou.com)06/01 Report--

1. Source database:

SQL > show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

-

2 PDB$SEED READ ONLY NO

3 PDB READ WRITE NO

4 TEST READ WRITE NO

two。 Target Library:

SQL > show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

-

2 PDB$SEED READ ONLY NO

3 PDB READ WRITE NO

SQL >

Migrate the TEST of the source library to the target library.

Operations on the source database:

SQL > alter pluggable database test close immediate

Pluggable database altered.

SQL > show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

-

2 PDB$SEED READ ONLY NO

3 PDB READ WRITE NO

4 TEST MOUNTED

SQL > alter pluggable database test unplug into'/ u01max test.xml'

Pluggable database altered.

Target Library:

[oracle@ora12cA cdb] $mkdir / u01/app/oracle/oradata/cdb/test

[oracle@ora12cA cdb] $mkdir / u01/test

Source database:

[oracle@ora12c] $scp-r / u01/test/test.xml oracle@192.168.10.32:/u01/test/test.xml

[oracle@ora12c ~] $scp-r / u01 oracle@192.168.10.32:/u01/app/oracle/oradata/cdb/test/

Target Library:

SQL > create pluggable database test using'/ u01Charger test.xml' nocopy tempfile reuse

Pluggable database created.

SQL > show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

-

2 PDB$SEED READ ONLY NO

3 PDB READ WRITE NO

4 TEST MOUNTED

SQL > exec DBMS_PDB.SYNC_PDB ()

PL/SQL procedure successfully completed.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.