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=XXX.dmp- works fine
- expdb abcadmin@abcpdb directory=EXPORT_DATA dumpfile=abc.dmp - error
UDE-12154: operation generated ORACLE error 12154
ORA-12154: TNS:could not resolve the connect identifier specified
I am able to connect to both pdb's via sql developer. and my listener has all pdb's listed with the fully qualified names.
Also, i've defined the directories in the pdb's.
Any ideas? thanks