Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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)

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

Summary

Pluggable cloud db datapump (expdp/impdp)

Content

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.

Register

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