Home » RDBMS Server » Server Administration » import error
import error [message #217496] Fri, 02 February 2007 09:31 Go to next message
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 Go to previous message
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
Previous Topic: Problems with Archivelogmode
Next Topic: ORA-02049
Goto Forum:
  


Current Time: Sun Dec 04 02:40:10 CST 2016

Total time taken to generate the page: 0.09813 seconds