Can some one see what I am missing/doing wrong? I am attempting to import
data from a parfile to get data from a partitioned table to non-partitioned
table and am getting the following error. i have truncated the tables and
set ignore=y. is that not enough?
FILE=\\lon1-gdwt\f$\Oracle\GDWSTG\Backups\GDWSTG_CONSOL_EXP.DMP
LOG=\\lon1-gdwt\f$\Oracle\GDWSTGT\Backups\GDWSTG_CONSOL_IMP.log
STATISTICS=NONE
FROMUSER=CONSOL
TOUSER=CONSOL
TABLES=(
INVOICE,
INVOICE_ITEM,
JOURNAL_ENTRY,
JOURNAL_ENTRY_LINE,
ORDER_DETAIL,
ORDER_HEADER,
RMA_DETAIL,
RMA_HEADER,
RMA_NOTES)
CONSTRAINTS=N
INDEXES=N
IGNORE=Y
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
Oracle DBA hopeful
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 11 2005 - 15:41:43 CDT
