Lin Hong's TECH Blog! 刀不磨要生锈,人不学习要落后 - Thinking ahead

Oracle Create PDB Tips

2020-09-13

Oracle Create PDB Tips

Create pluggable nologging option

Using nologging to reduce the time of creating pdb.

21:48:29 SYS@PRODCDB> @1.sql
21:48:30 SYS@PRODCDB> create pluggable database pdbprod3 from pdbprod1 file_name_convert=('PDBPROD1','PDBPROD3') nologging;

Pluggable database created.

21:49:00 SYS@PRODCDB> 
21:49:18 SYS@PRODCDB> @2.sql
21:49:18 SYS@PRODCDB> create pluggable database pdbprod6 from pdbprod1 file_name_convert=('PDBPROD1','PDBPROD6');

Pluggable database created.

21:50:02 SYS@PRODCDB> 
nologging: 30 seconds
logging  : 34 seconds

Reference

Create Pluggable database PDB Tips
Administrator's Guide 
--> 38 Creating and Removing PDBs with SQL*Plus 
--> Creating a PDB by Cloning an Existing PDB or Non-CDB
--> Cloning a Local PDB

Have a good work&life! 2020/09 via LinHong


Similar Posts

Comments