You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Pluggable cloud db datapump (expdp/impdp)

Received Response
edited Nov 2, 2017 7:00AM in Database 3 comments


Pluggable 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.

  1. expdp xyzadmin@xyzpdb  directory=EXPORT_DATA dumpfile=****.dmp- works fine
  2. expdb abcadmin@abcpdb directory=EXPORT_DATA dumpfile=abc.dmp -

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!