Skip to Main Content

Database Software

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!

is it possible to export and import only constraints for a specific schema ?

JhilApr 9 2019 — edited Apr 15 2019

Dear Experts,

is it possible to export and import only constraints for a specific schema ?

There are n number of objects in a schema.

impdp process is very slow and running 16+ hours ..continuously.

We are planning to export only constraints and import them.

How do i EXCLUDE remaining objects like INDEXES, FUNCTIONS, TRIGGERS, etc .. (EXCEPT CONSTRAINTS)

I want to exclude all objects including table rows, only i want to export CONSTRAINTS.

Can anyone tell me the best approach to achieve this ?

DB Version is 12.2

FYI : I have noticed, library cache lock occurred after impdp process initiated.

Thanks in advance

Comments

Post Details

Added on Apr 9 2019
6 comments
10,971 views