Datapump using PDB
If you are planning to export some data from PDB you need to make sure you have TNS entry in TNSNAMES.ORA. This is a prerequisite.
Lets now connect to PDB using expdp utility.
This is because there is no DATA_PUMP_DIRECTORY for the PDB.
Lets create a directory at the OS level and also at the DB level.
Lets test now by explicitly specifying the directory parameter.
Now the export is successful.
The New directory will only be displayed only in the corresponding container database.
Below screenshot will explain you the difference.
Connect to the Container database ORC1
If you are planning to export some data from PDB you need to make sure you have TNS entry in TNSNAMES.ORA. This is a prerequisite.
Lets now connect to PDB using expdp utility.
This is because there is no DATA_PUMP_DIRECTORY for the PDB.
Lets create a directory at the OS level and also at the DB level.
Lets test now by explicitly specifying the directory parameter.
Now the export is successful.
The New directory will only be displayed only in the corresponding container database.
Below screenshot will explain you the difference.
Connect to the Container database ORC1
No comments:
Post a Comment