This content has been marked as final. Show 4 replies
1 person found this helpful
CONSTRAINTS=Yuncomment ignore=y and proceed with import. Any reason why not using oracle database pump export and import?
That is an excellent question...my response is, that is the way the former DBA ran it.
I am new to this environment 2 months. I would like to switch, any great recommendations?
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!