Import Error

From: Connie Milliken <cemail_219_at_hotmail.com>
Date: Wed, 26 Dec 2007 08:52:20 -0500
Message-ID: <BAY140-W34029417A1660F078A1AAEA55B0@phx.gbl>

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

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

Received on Wed Dec 26 2007 - 07:52:20 CST