Re: Import Error

How about doing import with statistics=none ?

On Dec 26, 2007 6:59 AM, Kerber, Andrew W. <Andrew.Kerber_at_umb.com> wrote:

> 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_122007>
>
>
> ------------------------------------------------------------------------------
> 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