Techniques for Creating a PDB Technique Description More Information Create a PDB from scratch Create a PDB in a CDB using the files of the…
View More Creating a Pluggable Database Release 19
Tag: multitenant
Unplug and Plugin Pluggable database (PDB)
Oracle has introduced new Multitenant Option from Oracle 12cR1 and this option allows a single container database (CDB) to host multiple pluggable databases. One of the most powerful feature…
View More Unplug and Plugin Pluggable database (PDB)
Datapump export/import from Source PDB to Target PDB and with network_link
Source : target: Alternatively direct import with network_link without exporting in source add pdb record in tnsnames.ora add pdb service in listener.ora of source node101…
View More Datapump export/import from Source PDB to Target PDB and with network_link
Drop Pluggable Database (SQLPLUS command line or DBCA)
SQLPLUS show pdbs; alter pluggable database orclpdb close instances=all; drop pluggable database orclpdb including datafiles; DBCA
View More Drop Pluggable Database (SQLPLUS command line or DBCA)
How To Setup Listener For PDBS In Multitenant Database.
If you wish to setup listener for a particular PDB in the multitenant database, then follow as below. Create a listener and start it. LISTENER_DBATEST…
View More How To Setup Listener For PDBS In Multitenant Database.
Multitenant : DBCA PDB Remote Clone in Oracle Database 19c
Oracle Database 12c Release 2 (12.2) introduced the ability to perform a hot clone of a remote pluggable database (PDB) using the CREATE PLUGGABLE DATABASE command. In…
View More Multitenant : DBCA PDB Remote Clone in Oracle Database 19c
Hot Cloning a Remote PDB or Non-CDB
Prerequisites The prerequisites for cloning a remote PDB or non-CDB are very similar, In this context, the word “local” refers to the destination or target…
View More Hot Cloning a Remote PDB or Non-CDB