Database Reference
In-Depth Information
FiGUReĀ 11.25 Creating a PDB from an unplugged PDB: Success
3. Shut down the source non-CDB.
4. Create the target PDB data file directory that will be used in the FILE_NAME_CONVERT
clause.
5. Connect to the CDB ( NDLNE in the sample).
6. Create the new PDB from the non-CDB, using the COPY and FILE_NAME_CONVERT
key terms.
7. Connect to the new PDB and complete the PDB provisioning.
C:\> set ORACLE_SID=ORCL
C:\> set ORACLE_HOME=C:\Oracle\product\12.1.0\dbhome_2
C:\> sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Sun Nov 24 23:08:37 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 5027536896 bytes
Fixed Size 2412928 bytes
Variable Size 704646784 bytes
Database Buffers 4311744512 bytes
Redo Buffers 8732672 bytes
Database mounted.
SQL>
SQL> alter database open read only;
Database altered.
SQL> BEGIN
2 DBMS_PDB.DESCRIBE(
3 pdb_descr_file => 'c:\oracle\temp\ncdb.xml');
4 END;
5 /
PL/SQL procedure successfully completed.
Search WWH ::




Custom Search