I was Loading data into Development Environment Table using IMPDP So, somewhere in that process looks like the data which was importing was already got imported and IMPDP started failing with ORA-00001: unique constraint violated.
I went with DATA_OPTIONS=SKIP_CONSTRAINT_ERRORS parameter to let the IMPORT go. I Know, this option basically defeats the main feature of DIRECT PATH load and import will be slow but figured it would be rather more simpler than trying to find duplicates.
In my situation I can ignore duplicate records which are already existed. So I used DATA_OPTIONS=SKIP_CONSTRAINT_ERRORS.
I went with DATA_OPTIONS=SKIP_CONSTRAINT_ERRORS parameter to let the IMPORT go. I Know, this option basically defeats the main feature of DIRECT PATH load and import will be slow but figured it would be rather more simpler than trying to find duplicates.
In my situation I can ignore duplicate records which are already existed. So I used DATA_OPTIONS=SKIP_CONSTRAINT_ERRORS.
No comments:
Post a Comment