Re: Import Error

Hi:

You need to check the index difference between development and the production database.

Is there an index named PK_DRTY on table USERIDNAME in production database?

However, you could ignore this error.

Thanks.

• Fangxin Lou, Oracle DBA, from China

Good tools make work easy and improve life quality
-- http://www.dbatools.net

Personal software, life, research and professional Oracle recovery service
-- http://www.anysql.net/en

• http://www.anysql.net (Chinese)

From£º Connie Milliken
Sent£º 2007-12-26 21:57:43
To£º oracle-l_at_freelists.org
CC£º
Subject£º Import Error
I am getting the following import error on a 10.2.0.3 database and I am not sure what it means or if it should just be ignored. I truncated a schema in the database and then took an export file from another developmental database and was trying to import it into this database and got this error.    

IMP-00017: following statement failed with ORACLE error 20000:  "BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PK_DRTY"',NULL,NULL,NU"  "LL,0,0,0,0,0,0,0,6); END;"

IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "USERIDNAME"."PK_DRTY" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 2121
ORA-06512: at "SYS.DBMS_STATS", line 5394
ORA-06512: at line 1
 

Share life as it happens with the new Windows Live. Share now!

--
http://www.freelists.org/webpage/oracle-l