PARAMETER_NAME TYPE VALUE ------------------------------------------------------------ --------------------------------- ----------------------------------------------- db_name string test sys@TEST> select name, cdb from v$database;
NAME CDB --------------------------- --------- TEST NO
sys@TEST> select instance_name from v$instance;
INSTANCE_NAME ------------------------------------------------ test
NAME CDB --------------------------- --------- ORA12C YES
检查源库是否能被插入到目标库
1 2 3 4 5 6 7 8 9 10 11 12
set serveroutput on DECLARE compatible BOOLEAN := FALSE; BEGIN compatible := DBMS_PDB.CHECK_PLUG_COMPATIBILITY( pdb_descr_file => '/u01/app/oracle/oradata/test/test.xml'); if compatible then DBMS_OUTPUT.PUT_LINE('YES'); else DBMS_OUTPUT.PUT_LINE('NO'); end if; END; /
如果返回NO,则需要检查原因
1 2 3 4
col cause for a30 col name for a10 col message for a80 select name,cause,type,message,status from PDB_PLUG_IN_VIOLATIONS where name='TEST';
用刚才生成的XML文件创建一个新的PDB
1 2 3 4 5
CREATE PLUGGABLE DATABASE test USING '/u01/app/oracle/oradata/test/test.xml' COPY FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/test/', '/u01/app/oracle/oradata/ora12c/test/');