Your customer has two CDBs: one for Production and one for development. You are asked to create a new development PDB (salesdev) from an existing production PDB (salesprd). Which two options would accomplish this?
A.
You copy all the PDBSSEEDdata files from the production CDB into the development CDB and execute this on the development CDB;
SQL> CREATE PLUGGABLE DATABASE salesdev ADMIN USER salesdm IDENTIFIED by password;
B.
You alter the salesprd source database to open in read-only mode, and start cloning the source database:
SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;
SQL> CREATE PLUGGABLE DATABASE salesdev FROM salesprd;
C.
You alter the salesprd source database to open in read-only mode:
SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;
In the development CDB, you create a databaselink "PRD" that connects to the root of the source CDB, and start cloning the source PDB:
You can use the CREATE PLUGGABLE DATABASE statement to create a PDB in a CDB using the files of the seed.
D: Plugging In an Unplugged PDB
To plug in an unplugged PDB, the following prerequisites must be met:
* Complete the prerequisites described in "Preparing for PDBs".
* The XML file that describes the PDB must exist in a location that is accessible to the CDB.
The USING clause must specify the XML file.
Etc
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit