Re: Import Help

Bryan Wells wrote:

>
>
> IMP-00017: following statement failed with ORACLE error 20000:
> "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C105';
> SREC.MAXVAL "
> ":= 'C32C065D'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS :=
> DBMS_STA"
> "TS.NUMARRAY(4,430592); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1);
> SREC.EPC :="
> " 2;
> DBMS_STATS.SET_COLUMN_STATS(NULL,'"INVOICE"','"DW_SOLD_TO_CUSTOMER_ID"'"
> ",'"CONSOL_INVOICE_FY05"',NULL,NULL,3137,.000318775900541919,0,srec,4,0);
> EN"
> "D;"
> IMP-00003: ORACLE error 20000 encountered
> ORA-20000: Unable to set values for column DW_SOLD_TO_CUSTOMER_ID:
> does not exist or insufficient privileges
> ORA-06512: at "SYS.DBMS_STATS", line 3365
> ORA-06512: at "SYS.DBMS_STATS", line 3523
> ORA-06512: at line 1
>
> --
> Bryan Wells
> bunjibry_at_gmail.com <mailto:bunjibry_at_gmail.com>
> Oracle DBA hopeful

What is confusing as heck is how are you getting DBMS_STATS errors in the import file when you specified
STATISTICS=NONE. Do you have a trigger (login trigger, perhaps?) specifying something like that?

-- 
Mladen Gogala
Oracle DBA
Ext. 121


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