RE: Import Help
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <bunjibry@xxxxxxxxx>, "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 12 Aug 2005 07:43:34 -0400
Bryan,
What Oracle account are you using to run the import command? Is it the
CONSOL user? Does this user have IMP_FULL_DATABASE role? I think this
is a permissions problem where maybe you can create the tables but do
not have permissions to import the stats to the tables/columns. Does
the table get created correctly in the CONSOL account?
Tom
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bryan Wells
Sent: Thursday, August 11, 2005 4:40 PM
To: Oracle-L
Subject: Import Help
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@xxxxxxxxx
Oracle DBA hopeful
Other related posts:
