OraFAQ Forum: Server Utilities » SQL Laoder Date Handling

Home » RDBMS Server » Server Utilities » SQL Laoder Date Handling (Oracle 10g)

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

SQL Laoder Date Handling [message #571765]

Fri, 30 November 2012 03:49

vino06cse57
Messages: 128
Registered: July 2011
Location: chennai

Senior Member

Hi

I will get the data in DD-MM-YYYY format in CSV file.
When i am using SQL Loader to load the data from CSV file it throws invalid month error.

Deafult Date Format in my DB id DD-Mon-YY

Please help me in resolving it.

Here is the Control File

LOAD DATA
INFILE 'C:\Users\vinodkumar\Desktop\Date.txt' 
BADFILE 'C:\Users\vinodkumar\Desktop\Date.bad'
DISCARDFILE 'C:\Users\vinodkumar\Desktop\Date.dsc'

INTO TABLE "FINCALIVE"."BI_TEST_DATE"
APPEND
FIELDS TERMINATED BY ','
(MIS_DATE)

Sample Date:
MIS_DATE
--------------
30-11-2012
01-12-2012
02-12-2012
03-12-2012
04-12-2012
05-12-2012
06-12-2012
07-12-2012
08-12-2012
09-12-2012
10-12-2012
11-12-2012
12-12-2012
13-12-2012
14-12-2012
15-12-2012
16-12-2012
17-12-2012
18-12-2012
19-12-2012
20-12-2012

Report message to a moderator

Re: SQL Laoder Date Handling [message #571767 is a reply to message #571765]

Fri, 30 November 2012 03:55

Michel Cadot
Messages: 54226
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You have to give the date format in the control file.

Regards
Michel

Report message to a moderator

Re: SQL Laoder Date Handling [message #571769 is a reply to message #571767]

Fri, 30 November 2012 03:59

Michel Cadot
Messages: 54226
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

(MIS_DATE DATE "DD-MM-YYYY")

Regards
Michel

Report message to a moderator

Re: SQL Laoder Date Handling [message #571777 is a reply to message #571769]

Fri, 30 November 2012 04:50

vino06cse57
Messages: 128
Registered: July 2011
Location: chennai

Senior Member

hi Mike

Still i cant able to perfrom.when i use Toad Sql loaeder wizard.its overriding the control file.even though i secify the Date format

Report message to a moderator

Re: SQL Laoder Date Handling [message #571778 is a reply to message #571777]

Fri, 30 November 2012 04:59

Michel Cadot
Messages: 54226
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Through away TOAD.

Regards
Michel

Report message to a moderator

Re: SQL Laoder Date Handling [message #571779 is a reply to message #571778]

Fri, 30 November 2012 05:11

Littlefoot
Messages: 16995
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

TOAD offers 2 options: one is to build a control file; another one is to use existing one. Which option did you use (so that it was "overriding the control file")? According to what you said, it seems that you HAVE a control file, but chose not to use it. Is that correct?

Report message to a moderator

Previous Topic:	Unable to import one procedure from full database dump ( 10g )
Next Topic:	Need to copy table with NCLOB column into another database (10g to 11g)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 07:56:19 CDT 2013

Total time taken to generate the page: 2.10306 seconds