Tuesday, September 12, 2023

How to create a pluggable database with dbca using the command line

In the following code snippet, I am creating the pluggable database "pdb3" as a copy of the already existing pluggable database "pdb1":
dbca -silent -createPluggableDatabase \
-sourceDB cdb.skead.no \
-pdbName pdb3 \
-sourcePDB pdb1 \
-createPDBFrom PDB \
-pdbDatafileDestination "/dbfiles/oradata/cdb/pdb3/" \
-pdbAdminPassword mysecretpassword1 \
-sysPassword mysecretpassword2 \
-systemPassword mysecretpassword3 \
If you want to use the SEED database as source instead of an already existing database, remove the directive
-sourcePDB pdb1 \
and use this directive instead:
-createPDBFrom DEFAULT \
Source: Oracle 19c documentation

No comments:

Post a Comment