Import Help 2005-08-11 - By Bryan Wells
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 (See ORA-20000.ora-code.com): Unable to set values for column DW_SOLD_TO_CUSTOMER_ID: does not
exist or insufficient privileges
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_STATS", line 3365
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_STATS", line 3523
ORA-06512 (See ORA-06512.ora-code.com): at line 1
--
Bryan Wells
bunjibry@(protected)
Oracle DBA hopeful
<div>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?
</div>
<div> </div>
<div>FILE=\\lon1-gdwt\f$\Oracle\GDWSTG\Backups\GDWSTG_CONSOL_EXP.DMP<br>LOG=\
\lon1-gdwt\f$\Oracle\GDWSTGT\Backups\GDWSTG_CONSOL_IMP.log<br>STATISTICS=NONE<br
>FROMUSER=CONSOL<br>TOUSER=CONSOL<br>TABLES=(<br> INVOICE,<br> INVOICE
_ITEM,
<br> JOURNAL_ENTRY,<br> JOURNAL_ENTRY_LINE,<br> ORDER_DETAIL,<br
> ORDER_HEADER,<br> RMA_DETAIL,<br> RMA_HEADER,<br> RMA
_NOTES)<br>CONSTRAINTS=N<br>INDEXES=N<br>IGNORE=Y</div>
<div> </div>
<div>IMP-00017: following statement failed with ORACLE error 20000:<br>
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C105'; SREC
.MAXVAL "<br> ":= 'C32C065D'; SREC.EAVS := 0; SREC.CHVALS := NULL
;
SREC.NOVALS := DBMS_STA"<br> "TS.NUMARRAY(4,430592); SREC.BKVALS
:= DBMS_STATS.NUMARRAY(0,1); SREC.EPC :="<br> " 2; DBMS_STATS
.SET_COLUMN_STATS(NULL,'"INVOICE"','"DW_SOLD_TO_CUSTOMER_ID"
'"
<br> ",'"CONSOL_INVOICE_FY05"',NULL,NULL,3137,
.000318775900541919,0,srec,4,0); EN"<br> "D;"<br>IMP-00003:
ORACLE error 20000 encountered<br>ORA-20000 (See ORA-20000.ora-code.com): Unable to set values for column DW
_SOLD_TO_CUSTOMER_ID: does not exist or insufficient privileges
<br>ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_STATS", line 3365<br>ORA-06512 (See ORA-06512.ora-code.com): at "
;SYS.DBMS_STATS", line 3523<br>ORA-06512 (See ORA-06512.ora-code.com): at line 1<br clear="all"><br>--
<br>Bryan Wells<br><a href="mailto:bunjibry@(protected)">bunjibry@(protected)
</a><br>Oracle DBA hopeful </div>
|
|
