Pluggable cloud db datapump (expdp/impdp)
SummaryPluggable cloud db datapump (expdp/impdp)
Hello guys, I'm running oracle 12c database in the oracle dbaas cloud service. My db instance has multiple pdb's and I am trying to do a dump file export of each of the pdb's. (Ideally all pdb's export with a single command would be nice). Anyways, expdp command works fine for the default (or at least the first created pdb), however any attempt to execute the commands for the other pdb's give errors. e.g.
- expdp xyzadmin@xyzpdb directory=EXPORT_DATA dumpfile=****.dmp- works fine
- expdb abcadmin@abcpdb directory=EXPORT_DATA dumpfile=abc.dmp -