I was trying to import only schema belonging to one user, not the entire dump file. The import proceeded for a while and imported some tables successfully, then ended while importing a large table.
Now i got it , u want to have a USER created from the EXPORT FULL DUMP.
imp userid =system/manager fromuser=xxxx touser=xxxx file=export.dmp.
try doing this.
once u do this u will have the user and all the schema objects created.
Good luck. if u require any thing please question
Eat , Drink & Enjoy life -
I used user_a to import schema belonging to user_a from a full dump file. The import proceeded for a while and successfully imported some tables then ended abnormally while importing a big table (see the record of the whole process in my previous post). I think I get the import started correctly. However, it ended in the middle of the import. I suspect the database could not start the archivelog so the import stopped. Hope this time I explained my question clearly.
IMP-00009: abnormal end of export file
I suspect input file corruption or incompleteness.
Try reading input file from start to end using...
imp system/manager file=fname show=y full=y
Click Here to Expand Forum to Full Width