OraFAQ Forum: Server Utilities » SQL LOADER data file error problem with date

Home » RDBMS Server » Server Utilities » SQL LOADER data file error problem with date

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL LOADER data file error problem with date [message #72085]

Wed, 05 March 2003 06:46

Victoria
Messages: 152
Registered: July 2002

Senior Member

Hi,
In my CSV file i have the date field as '1/1/2001'.But in my control file i gave

UPDT_DATE DATE 'MM/DD/YYYY',

But the field can contain '12/12/2003' also.
Moreover sometimes the same date field in CSV file can contain time stamp also...
How to handle this problem???

2).Can i give absolute input data file path name in control file?.

3).I need to have same control file and input file for loading more than one table.
Here the first 50 records are for table1,the next 50 are for table2 and the rest are for table3.

Any idea????
Thanks
~V~

Report message to a moderator

Previous Topic:	Calling DOS batch files or other exe's from Oracle Stored Procs
Next Topic:	conditional uploading using SQL Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 10:00:20 CST 2025