OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Imp gives error.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Imp gives error. [message #221995]

Thu, 01 March 2007 07:35

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

Hi.

Could you please see the following details and give me suggesstion

IMP-00003: ORACLE error 20000 encountered
ORA-20000: Unable to set values for table XYZ: does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 4020
ORA-06512: at "SYS.DBMS_STATS", line 4111
ORA-06512: at line 1

This is happening when i do import, but the export is done by different user.

oracle 9i release 2

Thanks,
Shahnaz.

Report message to a moderator

Re: Imp gives error. [message #222019 is a reply to message #221995]

Thu, 01 March 2007 08:26

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
This is happening when i do import, but the export is done by different user.
What import command your using ?

ORA-20000: Unable to set values for table XYZ: does not exist or insufficient privileges
basically ORA-20000 is user define error. but XYZ table is exists or you have sufficient privs.

REGARDS
Taj

Report message to a moderator

Re: Imp gives error. [message #222040 is a reply to message #221995]

Thu, 01 March 2007 09:06

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

export must have done with statistics (default).
While import you are not having privileges over all underlying objects (tables/index) to set the statistics again.
Do the import as DBA user or acquire the privs.

Report message to a moderator

Previous Topic:	8i to 9i
Next Topic:	Import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:29:25 CDT 2024