| SQL LOADER PROBLEM [message #119193] |
Wed, 11 May 2005 02:21  |
puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India
|
Member |
|
|
Hi Group,
Hope everyone doing well.
Well guys I'm stuck with a very stupid problem
Please help me and guide me.
I have a control file which says
--------------------------------------------------------------
LOAD DATA
INFILE 'C:\stockbreakdata.txt' BADFILE 'C:\stockbreakdata.bad'
DISCARDFILE 'C:\stockbreakdata.dis'
INTO TABLE TEST_LDR
fields terminated by ","
(
ID INTEGER,
SEC CHAR,
SEC_DESC CHAR,
CLASS CHAR,
RATES INTEGER,
DOB DATE "DD-MON-RRRR"
)
----------------------------------------------------------------
and data is
----------------------------------------------------------------
1,"SEC NO 1","SEC DESC 1","XYZ",288.800,"05-MAY-2005"
2,"SEC NO 2","SEC DESC 2","XYZ",288.800,"05-MAY-2005"
3,"SEC NO 3","SEC DESC 3","XYZ",288.800,"05-MAY-2005"
-----------------------------------------------------------------
And its showing error in log file as..
Record 1: Rejected - Error on table TEST_LDR, column DOB.
ORA-01847: day of month must be between 1 and last day of month
My table description is
ID NUMBER
SEC VARCHAR2(20)
SEC_DESC VARCHAR2(400)
CLASS VARCHAR2(100)
RATES NUMBER
DOB DATE
Please help me..
its urgent.
Regards
Puneet Sachar
Incase u want I can upload my ctl and data file also.
|
|
|
|
| Re: SQL LOADER PROBLEM [message #119197 is a reply to message #119193] |
Wed, 11 May 2005 02:42  |
 |
Barbara Boehmer
Messages: 9102
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
LOAD DATA
INFILE 'C:\stockbreakdata.txt' BADFILE 'C:\stockbreakdata.bad'
DISCARDFILE 'C:\stockbreakdata.dis'
INTO TABLE TEST_LDR
fields terminated by ","
OPTIONALLY ENCLOSED BY '"'
(
ID INTEGER EXTERNAL,
SEC CHAR,
SEC_DESC CHAR,
CLASS CHAR,
RATES INTEGER EXTERNAL,
DOB DATE "DD-MON-RRRR"
)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
