Home » RDBMS Server » Server Utilities » IMP-00018: partial import of previous table completed (Oracle 11g, AIX 5.3)
IMP-00018: partial import of previous table completed [message #526587] Tue, 11 October 2011 14:55 Go to next message
dbarocks
Messages: 6
Registered: October 2011
Junior Member
Hi,

I am trying to import the schema into 11g databse, which i took on Oracle 9i database. While import is running, data file is full as auto extension was not enabled.
I got the following error:

. . importing table "WO_GL_ACCOUNT_SUMMARY"
IMP-00058: ORACLE error 1653 encountered
ORA-01653: unable to extend table PWRPLANT.WO_GL_ACCOUNT_SUMMARY by 1024 in tabl
espace PWRPLANT
IMP-00018: partial import of previous table completed: 7055845 rows imported.


Then I increased the datafile size and finally Import terminated successfully with warnings.

At this point, I want to know whether WO_GL_ACCOUNT_SUMMARY Table was imported with out missing any rows .. Please advice...

Thanks

Re: IMP-00018: partial import of previous table completed [message #526588 is a reply to message #526587] Tue, 11 October 2011 15:10 Go to previous messageGo to next message
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
Senior Member
Do a count of the rows in the table. Does it match the export?
Re: IMP-00018: partial import of previous table completed [message #526589 is a reply to message #526587] Tue, 11 October 2011 15:37 Go to previous messageGo to next message
dbarocks
Messages: 6
Registered: October 2011
Junior Member
No, it's not matching..


SQL> select count(*) from WO_GL_ACCOUNT_SUMMARY;

COUNT(*)
----------
7055845

SQL> select count(*) from WO_GL_ACCOUNT_SUMMARY;

COUNT(*)
----------
23222968

And also, I got couple of errors during import:

. . importing table "WO_GL_ACCOUNT_SUMMARY_PREVIOUS"
IMP-00058: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace PWRPLANT
. . importing table "WO_GRP_WO_TYPE" 0 rows imported
. . importing table "WO_IMAGE_INTERFACE" 0 rows imported
. . importing table "WO_PROCESS_CONTROL" 325 rows imported
. . importing table "WO_REIMBURSABLE" 0 rows imported
. . importing table "WO_SUMMARY"

IMP-00058: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace PWRPLANT
. . importing table "WO_TYPE_CLEAR_DFLT"
IMP-00058: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace PWRPLANT


after I increased data file size, some tables were imported fine and for some tables, I got IMP-00058 errors. Could any one explain the reason..


Can I import these tables again with IGNORE=Y option?? or any better solution??


Thanks.

Re: IMP-00018: partial import of previous table completed [message #526592 is a reply to message #526589] Tue, 11 October 2011 15:48 Go to previous messageGo to next message
John Watson
Messages: 8429
Registered: January 2010
Location: Global Village
Senior Member
Hi - this may be too late for you on this occasion, but when you run the import again, I would always enable the RESUMABLE feature. This means that if the import hits a space problem, instead of failing it will hang - and wait for you to fix the problem. When you add another datafile (or whatever else is necessary) it will wake up and carry on. All you have to do is add these parameters to your imp command:

resumable=y resumable_timeout=whatever_value_you_want


Re: IMP-00018: partial import of previous table completed [message #526594 is a reply to message #526587] Tue, 11 October 2011 16:07 Go to previous messageGo to next message
dbarocks
Messages: 6
Registered: October 2011
Junior Member
Hi John,

As you mentioned, why there is difference of rows from export and import when i increased data file size and import continued..

--Thanks
Re: IMP-00018: partial import of previous table completed [message #526622 is a reply to message #526594] Wed, 12 October 2011 00:55 Go to previous messageGo to next message
Michel Cadot
Messages: 67569
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is a difference of rows because the import failed to import all the rows due to lack of space, skip the rest of the table and go to the next one.
This is clearly mentioned in the message:

Quote:
IMP-00018: partial import of previous table completed: 7055845 rows imported


Regards
Michel
Re: IMP-00018: partial import of previous table completed [message #526709 is a reply to message #526589] Wed, 12 October 2011 09:59 Go to previous messageGo to next message
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
Senior Member
dbarocks wrote on Tue, 11 October 2011 16:37

And also, I got couple of errors during import:

. . importing table "WO_GL_ACCOUNT_SUMMARY_PREVIOUS"
IMP-00058: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace PWRPLANT
. . importing table "WO_GRP_WO_TYPE" 0 rows imported
. . importing table "WO_IMAGE_INTERFACE" 0 rows imported
. . importing table "WO_PROCESS_CONTROL" 325 rows imported
. . importing table "WO_REIMBURSABLE" 0 rows imported
. . importing table "WO_SUMMARY"

IMP-00058: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace PWRPLANT
. . importing table "WO_TYPE_CLEAR_DFLT"
IMP-00058: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace PWRPLANT


If it could not create the initial extent, the table would not have been imported at all, meaning not only would it have no rows, the table would not exist.
You should really never have this case unless someone is a little shortsighted. Before doing an import the first thing I would do is to make sure I have enough space. In a locally managed tablespace, you should never get an ORA-1658 unless you just do not have any space at all left in the tablespace, which you previously stated you do not.
You really should have checked free space before doing such a large import.
the only thing you can do now to fix you problem with the partial table is to drop it and reimport.
Re: IMP-00018: partial import of previous table completed [message #526713 is a reply to message #526622] Wed, 12 October 2011 10:28 Go to previous message
dbarocks
Messages: 6
Registered: October 2011
Junior Member
Thanks for your suggestions...
Previous Topic: explain import and export database in oracle ?
Next Topic: SQL*Loader: Error inserting number with U.S. formatting using modified CHARACTERSET (merged 2)
Goto Forum:
  


Current Time: Fri Dec 04 00:02:17 CST 2020