Database Utilities (MOSC)

MOSC Banner

sql loader error

edited Mar 21, 2012 5:53AM in Database Utilities (MOSC) 4 commentsAnswered
DABASE ORACLE 10G RELEASE 10.2.0.4.0

I AM TRYING to LOAD data into TABLE test with the following structure
X1           NUMBER(7)    
X2            NUMBER(7)    
X3            NUMBER(3)    
X4           NUMBER(5)    
X5           VARCHAR2(75) 
X6           NUMBER(17)   
X7           NUMBER       
X8          VARCHAR2(6)  
X9          VARCHAR2(4)  
X10        VARCHAR2(15) 
X11         VARCHAR2(15) 
X12         NUMBER       
X13          NUMBER       
X14          VARCHAR2(4)  
X15           varchar2(2) 

SQL LOADER  CONTROL FILE SCRIPT
------------------
LOAD data
infile 'E:\OracleProcessing\flatfiles\rate.txt'
badfile 'E:\OracleProcessing\flatfiles\Rate_Change_01_01.bad'
discardfile 'E:\OracleProcessing\flatfiles\Rate_Change_01_01.dis'
TRUNCATE
into table test
(X1               POSITION(001:007)       INTEGER external,
 X2                             POSITION(008:014)       INTEGER external,
 X3                            POSITION(015:017) integer external,
 X4                POSITION(018:022) integer external,
 --X5             position(023:060) CHAR "UPPER(TRIM(:CUST_NAME))",

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center