| IMP-00018: partial import of previous table completed [message #526587] |
Tue, 11 October 2011 14:55  |
 |
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 #526592 is a reply to message #526589] |
Tue, 11 October 2011 15:48  |
John Watson
Messages: 8962
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 #526709 is a reply to message #526589] |
Wed, 12 October 2011 09:59 |
joy_division
Messages: 4963
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
