RE: Import Error

From: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Wed, 26 Dec 2007 08:59:38 -0600
Message-ID: <D40740337A3B524FA81DB598D2D7EBB30C391C30@x6009a.umb.corp.umb.com>

Does this happen on all attempts to execute the dbms_stats package, or just this one?

Are you importing as yourself or as sys or system?

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Connie Milliken Sent: Wednesday, December 26, 2007 7:52 AM To: oracle-l_at_freelists.org
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.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_12 2007>

NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

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

Received on Wed Dec 26 2007 - 08:59:38 CST