-- Generate xml file of pdb BEGIN DBMS_PDB.RECOVER(PDB_DESCR_FILE => "/yxq5/lomon/ODBA_AO_011_011.xml", PDB_NAME => "ODBA_AO_011_011", FILENAMES => "/yxq5/lomon"); END; / -- Check compatibility of pdb SET SERVEROUTPUT ON DECLARE theResult BOOLEAN; BEGIN theResult := DBMS_PDB.check_plug_compatibility( pdb_descr_file => "/yxq5/lomon/ODBA_AO_011_011.xml", pdb_name => "ODBA_AO_011_011"); IF theResult THEN DBMS_OUTPUT.PUT_LINE("PDB is compatible"); ELSE DBMS_OUTPUT.PUT_LINE("PDB is not compatible"); END IF; END; / -- Create Pluggable Database CREATE PLUGGABLE DATABASE ODBA_AO_011_011 USING "/yxq5/lomon/ODBA_AO_011_011.xml" NOCOPY; ALTER PLUGGABLE DATABASE ODBA_AO_011_011 open; SELECT name, con_id FROM v$pdbs WHERE name="ODBA_AO_011_011"; -- Re-create Temporary Tablespace SELECT property_name, property_value FROM database_properties WHERE property_name LIKE ‘%TEMP%’; SELECT file_name FROM dba_temp_files; CREATE TEMPORARY TABLESPACE temp1 TEMPFILE "/u01/app/oracle/oradata/cdb3/datafile/pdb1_temp01.dbf" SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE unlimited EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M; ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp1; DROP TEMPORARY TABLESPACE TEMP; SELECT * FROM PDB_PLUG_IN_VIOLATIONS;