This content has been marked as final. Show 4 replies
CONSTRAINTS=Yuncomment ignore=y and proceed with import. Any reason why not using oracle database pump export and import?
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!