Sponsored Links
ORACLE IMPORT - Is INDEXFILE complete after IMP-00009 error (dump > 2GB)
ORACLE IMPORT - Is INDEXFILE complete after IMP-00009 error (dump > 2GB)?
Oracle 9i on Windows 2000 Server.
I'm importing a large dump and I want to get the INDEXFILE first. While running the import with the "INDEXFILE=" option, I always bomb out with the "IMP-00009: abnormal end of export file" message.
I don't think the dump is corrupted because it will import without the indexfile option - it just tries to go to the wrong tablespaces. I'm guessing this is because the dump is larger than 2 GB.
It did create an indexfile, but since it got the error I wondered if it is complete. Can I reliably use this indexfile to create the tables and keys, or did it just end somewhere in the middle of it all?
A:
can you import just the structure (rows=n)
imp userid=/ file=yadda log=yadd.log rows=n fromuser=yadda touser=yadda
then
ALTER INDEX owner.index_name rebuild online tablespace NEW_TS;
disable triggers and FK constraints
imp userid=/ file=yadda log=yadd.log fromuser=yadda touser=yadda ignore=y
Page 1
|
| 
