Home » RDBMS Server » Server Administration » Imp gives error.
Imp gives error. [message #221995] Thu, 01 March 2007 07:35 Go to next message
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.

Re: Imp gives error. [message #222019 is a reply to message #221995] Thu, 01 March 2007 08:26 Go to previous messageGo to next message
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
Re: Imp gives error. [message #222040 is a reply to message #221995] Thu, 01 March 2007 09:06 Go to previous message
Mahesh Rajendran
Messages: 10672
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.
Previous Topic: 8i to 9i
Next Topic: Import
Goto Forum:
  


Current Time: Sun Dec 04 06:22:29 CST 2016

Total time taken to generate the page: 0.08213 seconds