Skip to Main Content
Forums

SQL & PL/SQL

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!

Best approach to track INDEXES AND CONSTRAINTS

JhilJul 20 2019 — edited Jul 20 2019

Hi Team,

We do export and import frequently.

IMPORT runs more time , because it creates indexes and constraints.

We decided to recreate them after import job.

Can anyone help me to track all indexes and constraints under the schema before we initiate EXPDP JOB.

It might help us to reduce the impdp job complexity

Thanks

Comments
Post Details
Added on Jul 20 2019
6 comments
658 views