Re: Import Help
- From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
- To: bunjibry@xxxxxxxxx
- Date: Thu, 11 Aug 2005 16:49:22 -0400
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@xxxxxxxxx <mailto:bunjibry@xxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
