This content has been marked as final. Show 2 replies
Uncommented the _"IGNORE=Y"_ on the IMP.par (parameter file).
Changed the "CONSISTENT=Y" to _"CONSISTENT=N"_
Actually we ran into an issue as we were only trying to import in the INDEXES and CONSTRAINTS, however, we were pulling STATISTICS as well.
We added _"STATISTICS=NONE"_ on both the EXP/IMP Parameter file to resolve this issue.
This also, sped up IMP/EXP times, shrunk the size of .dmp file, etc.
Recommend this, as it was helpful (my boss is brilliant).
Here's the final results - in case you run into in the future.
Hope this helpful!