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!

Need to Track Index and Constraints before i start EXPORT JOB

JhilJul 19 2019 — edited Jul 21 2019

Hi Experts ,

We are frequently doing export and import from Prod to UAT/STAGING Database Servers.

Import is running long time so we are always using EXLUDE=CONSTRAINTS , INDEXES during import.

Can anyone help me , how do i make a simple script to track all indexes and constraints before i take export.

once i tracked all indexes/constraints from the schema, using spool file i can recreate them.