OraFAQ Forum: Server Utilities » sqlldr: loading data with date

Home » RDBMS Server » Server Utilities » sqlldr: loading data with date

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

sqlldr: loading data with date [message #219708]

Thu, 15 February 2007 10:46

syang
Messages: 30
Registered: February 2007

Member

Hi All,

Does anyone know how to load data (with sqlloader) that has the following date pattern?

1. 12/27/2006 12:39:36 PM
2. 1/17/2007 7:03:03 AM

How will the control file be setup in order to deal with this date pattern?

...
(SUPLR_ID,
LGL_BUSNS_NAME,
LAST_CHG_DT date "mm/dd/yyyy hh:mm:ss")

My question is how to interprete this "PM and AM" in the control file.

Thanks for your advice!

Report message to a moderator

Re: sqlldr: loading data with date [message #219711 is a reply to message #219708]

Thu, 15 February 2007 10:56

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

use

"mm/dd/yyyy HH:MI:SS AM"

Report message to a moderator

Re: sqlldr: loading data with date [message #219713 is a reply to message #219711]

Thu, 15 February 2007 11:04

syang
Messages: 30
Registered: February 2007

Member

Thank you, Mahesh!

Your answer has solved my problem. Data has been successfully loaded after the fix. Thank you, gain!

Report message to a moderator

Importing CSV File in oracle table using TOAD [message #219956 is a reply to message #219708]

Sat, 17 February 2007 00:00

farrisoft
Messages: 1
Registered: February 2007
Location: Pakistan

Junior Member

Hi,
i have a .csv file in excel & i wanna import it into a table
in oracle 8i. but i m using TOAD tool for the oracle. plz guide
me how to make the control file .ctl & how to use the sql
loader. but all these within the TOAD.
regards,
Farrukh

Report message to a moderator

Re: sqlldr: loading data with date [message #219966 is a reply to message #219708]

Sat, 17 February 2007 00:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>how to use the sql loader. but all these within the TOAD.
Those who live by the GUI, die by the GUI.
SQLLDR is NOT a GUI utlity. It is command line driven. Deal with it.

Report message to a moderator

Previous Topic:	need document on export / import transportable TS
Next Topic:	Not Null Constraints Disappeared after import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 21:39:53 CST 2024