Creating Oracle Multitenant Databases - OCP: Oracle Database 12c Administrator Certified Professional - page 532

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0
- 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing
options
The command to create the PDB does not create the directories on the file system, so
using your preferred file system manager or the command line, create the target directory
for the PDB data files. Now update your environment variables to switch to the target CDB
and log on to SQL*Plus as SYSDBA . Once you're connected, plug in the non-CDB as a PDB.
C:\>mkdir C:\oracle\oradata\NDLNE\LNE2\DATAFILE
C:\>set ORACLE_SID=NDLNE
C:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Mon Nov 25 20:58:10 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing
options
SQL> CREATE PLUGGABLE DATABASE LNE2 USING 'c:\oracle\temp\ncdb.xml'
COPY
FILE_NAME_CONVERT = ('c:\oracle\oradata\ORCL\', 'c:\oracle\oradata\NDLNE\LNE2\
DATAFILE\');
Pluggable database created.
Now connect to the new PDB and run the %ORACLE_HOME%\rdbms\admin\noncdb_to_pdb
.sql script. You must run this script before the PDB can be opened for the first time. The
script will SET ECHO ON , open the new PDB, make its changes, and then close the PDB. Once
it's complete, alter the PDB to open it and begin using it. (The output is truncated here.)
SQL> alter session set container=LNE2;
Session altered.