Skip to Main Content
Forums

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!

Export Database Objects excluding Tables with DataPump

Ali Raza MemonFeb 28 2024

Dear community,

We have a task to export something like the following:

export all XXL% Objects from HR schema using EXPDP

Upon checking, it seems that there are no tables but other database objects:

The question is how to export these all objects and import them somewhere else using expdp/impdp?

Thanks!
This post has been answered by Solomon Yakobson on Feb 29 2024
Jump to Answer
Comments
Post Details
Added on Feb 28 2024
#expdp, #general-database-discussions, #impdp, #oracle, #schema, #user
5 comments
379 views
1 mention