Import Error

  • From: Connie Milliken <cemail_219@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 26 Dec 2007 08:52:20 -0500

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 encounteredORA-20000: INDEX 
"USERIDNAME"."PK_DRTY" does not exist or insufficient privilegesORA-06512: at 
"SYS.DBMS_STATS", line 2121ORA-06512: at "SYS.DBMS_STATS", line 5394ORA-06512: 
at line 1
 
_________________________________________________________________
Share life as it happens with the new Windows Live.
http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_122007

Other related posts: