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@xxxxxxxxxxxxx 
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!

Other related posts: