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!

How to Re-import Dump file from the very begin by using IMPDP, when some of db object has imported s

2684285Feb 7 2015 — edited Feb 13 2015

Dear all,

Two day before I have created Two tablespaces along with it's datafile(500 Gb), and i started impdp, but it was ending with error please find error below,

Job "SYSTEM"."SYS_IMPORT_FULL_02" completed with 35340 error(s) at Sat Feb 7 01:10:16 2015 elapsed 0 07:24:41,

From above msg i came to know Importing didn't completed successfully,but most of the table and index has been imported successfully,

Now i would like to drop all of imported object and start importing from the begin,

MY question is below,

1) When most of the object has imported successfully but result ending with error like below

Job "SYSTEM"."SYS_IMPORT_FULL_02" completed with 35340 error(s) at Sat Feb 7 01:10:16 2015 elapsed 0 07:24:41

then i would like to do import from very begin, So that i need to drop all successfully imported object except datafile and it's allocated space to get fresh instance.how to achieve it, Please help me, Thank in advance