现有一个非CDB的数据库ORCL,计划将其作为PDB,装入CDB2中。注:ORCL和CDB2都在同一服务器上。
进入ORCL,将其设置为只读模式
点击(此处)折叠或打开
-
startup mount
- alter database open read only;
点击(此处)折叠或打开
-
SQL> EXEC DBMS_PDB.DESCRIBE ('/tmp/ORCL.xml');
-
- PL/SQL procedure successfully completed.
现在进入CDB2
点击(此处)折叠或打开
- SQL> CREATE PLUGGABLE DATABASE PDB2 USING '/tmp/ORCL.xml';
- #确认结果
-
SQL> select * from cdb_pdbs;
点击(此处)折叠或打开
-
sqlplus sys@pdb2 as sysdba
- SQL> @?/rdbms/admin/noncdb_to_pdb
之后,打开PDB
点击(此处)折叠或打开
- SQL> ALTER PLUGGABLE DATABASE pdb2 OPEN;