Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database export of all pluggable databases from container database

user-cqxesSep 11 2023

Hii there,

I'm trying to export my pluggable databases from the root container. But when I'm using

expdp username/password@root_sid directory=dir_name dumpfile=export.dmp logfile=export.log full = y

It is only exporting the root container not the underlying pdbs in it.

How can I take export all the container databases including all the pluggables databases in it?

(I'm using oracle 19c database)

Thanks

Comments
Post Details
Added on Sep 11 2023
3 comments
4,382 views