Oracle 12c learning 3 converting nocdb to pdb and nocdbpdb
01:23:06 sys @ orcl> select name, decode (cdb, 'yes', 'multitenant Option enabled', 'regular 12c Database: ') "Multitenant Option", open_mode, con_id from v $ database; NAME Multitenant Option OPEN_MODE CON_ID --------- ---------------------------- ------------------ ----------------- ORCL Regular 12c Database: read write 0 the database is a traditional Database, instead of cdb, We will convert this database to cdb01: 27: 24 sys @ orcl> select name from v $ datafile; N AME example --- + DATA/ORCL/DATAFILE/system.354.874717421 + DATA/ORCL/DATAFILE/undotbs2.352.874718065 + DATA/ORCL/DATAFILE/example + DATA/ORCL/ DATAFILE/kiwi.328.87369845 + DATA/ORCL/DATAFILE/users.329.874717527 6 rows selected. E Lapsed: 00:00:00. 01 01:27:33 sys @ orcl> shutdown immediate; Database closed. database dismounted. ORACLE instance shut down. 01:28:46 sys @ orcl> startup restrict mount exclusive; ORACLE instance started. total System Global Area 2488635392 bytes Fixed Size 2291424 bytes Variable Size 721422624 bytes Database Buffers 1744830464 bytes Redo Buffers 20090880 bytes Database mounted.01: 29: 11 sys @ orcl> alt Er database open read only; Database altered. elapsed: 00:00:04. 42 01:30:28 sys @ orcl> begin 01:32:27 2 dbms_pdb.describe (PDB_DESCR_FILE => '/u02/noncdb/orcl. xml '); 01:32:27 3 end; 01:32:27 4/create pluggable database orcl using'/u02/noncdb/orcl. xml 'Copy; alter session set container = orcl; execute this script to convert to pdb @? /Rdbms/admin/noncdb_to_pdb. SQL