| New sqlldr user having problems loading date column [message #70730] |
Thu, 18 July 2002 08:55  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
I am unable to load the following date value "1995-08-30 01:00:00" (from MSSQL7) into an 8i table value defined as 'EstablishDate DATE NULL' using sqlldr. My ctl is as follows:
LOAD DATA
INFILE 'Customer_Test.dat'
INTO TABLE Customer_Test
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(CustID,...,EstablishDate DATE(20) 'YYYY-MM-DD HH24:MM:SS',...)
I have tried numerous masks, but most often I receive the "Record 1: Rejected - Error on table CUSTOMER_TEST, column ESTABLISHDATE.
ORA-01810: format code appears twice" error message.
I am a definite newbie at Oracle. Does anyone have any suggestions? Much thanks!!
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
