Home » RDBMS Server » Server Utilities » Import error while enabling constraints
Import error while enabling constraints [message #74171] Tue, 28 September 2004 05:18 Go to next message
Deep
Messages: 15
Registered: July 2001
Junior Member
Hi,

    I am trying to refresh an environment with a export .dmp file, I use the following imp command

imp sys file=filexxx.dmp log=filexxx.log fromuser=x touser=y commit=n indexes=n analyze=n

But when I run this tables get created but when it tries to enable the costraints I the following error

ORA-08103 : object no longer exists

I checked the backup file, it is not corrupted, could anybody suggest.

Thanks and Regards

Deep

 

 

 

Report message to a moderator

Re: Import error while enabling constraints [message #74172 is a reply to message #74171] Tue, 28 September 2004 05:47 Go to previous messageGo to next message
Dilip
Messages: 12
Registered: January 2002
Junior Member
Hi
remove analyze=n option

Regards

D.Dilip

Report message to a moderator

Re: Import error while enabling constraints [message #74173 is a reply to message #74172] Tue, 28 September 2004 06:45 Go to previous message
Deep
Messages: 15
Registered: July 2001
Junior Member
Dilip,

thx for the help, but I found the problem, the data block was corrupted in one of the data files, so recreating the tablespace will fix the issue.

Thanks and Regards
Deep Pilankar

Report message to a moderator

Previous Topic: Error at the time of Import
Next Topic: SQLLDR loading more records than in the file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 06:26:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.