RE: Import Help

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Fri, 12 Aug 2005 07:43:34 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF35FAEA@EXCNYSM0A1AJ.nysemail.nyenet>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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_at_gmail.com 
Oracle DBA hopeful 


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

Received on Fri Aug 12 2005 - 06:45:43 CDT