| import error [message #217496] |
Fri, 02 February 2007 09:31  |
nisha22
Messages: 6
Registered: September 2005
|
Junior Member |
|
|
Hi,
I am having an issue with an import. I need to know if one (or several) of you can help me with this. After the log completes, some tables import, but the following error appears in the log:
. . importing table "PS_GC_MLED_MGT_TBL" 217721 rows imported
IMP-00017: following statement failed with ORACLE error 604:
"ALTER TABLE "PS_GC_MLED_MGT_TBL" ADD CHECK (LENGTH(GC_SLED_TBLNAME)<=18) EN"
"ABLE"
IMP-00003: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-08103: object no longer exists
IMP-00017: following statement failed with ORACLE error 604:
"ALTER TABLE "PS_GC_MLED_MGT_TBL" ADD CHECK (LENGTH(GC_SOURCE)<=2) ENABLE"
IMP-00003: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-08103: object no longer exists
This error is intermittent; in other words, if I drop the table and import it with tables= afterward, it imports successfully.
Any help you can provide would be greatly appreciated.
Thank you,
|
|
|
|
| Re: import error [message #217587 is a reply to message #217496] |
Fri, 02 February 2007 22:25  |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
Hi,
Error: ORA-08103: object no longer exists
Cause: You tried to execute an operation that referenced an object that has been deleted by another user.
Action: The options to resolve this Oracle error are:
Re-create the object.
Remove your reference to the object.
Are you post your imp command.
regards
Taj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
