Home » RDBMS Server » Server Utilities » loading data in table by using sql loader (oracle 10g on linux 32 bit)
loading data in table by using sql loader [message #311435] Fri, 04 April 2008 08:45 Go to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
I have a table with following structure

create table C1
(
SEARCH NUMBER(10) not null,
FORENAME CHAR(15),
SURNAME CHAR(20),
NAME CHAR(15),
TITLE CHAR(15),
DOB TIMESTAMP(6),
ROWGUID CHAR(40) not null
)

when i am loading data by using following controlfile contents. It is not loading data saying that date type mismatch

LOAD DATA
APPEND
INTO TABLE <schema.c1>
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(
SEARCH INTEGER EXTERNAL,
FORENAME CHAR,
SURNAME CHAR,
NAME CHAR,
TITLE CHAR,
DOB TIMESTAMP "YYYY-MM-DD HH24:MI:SS.FF",
ROWGUID CHAR
)

my date format is following

19/07/1973 00:00

i also try with the following format

DOB TIMESTAMP "YYYY-MM-DD HH24:MI

[Updated on: Fri, 04 April 2008 10:14] by Moderator

Report message to a moderator

Re: loading data in table by using sql loader [message #311437 is a reply to message #311435] Fri, 04 April 2008 08:48 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
> It is not loading data saying that date type mismatch
The fix is to make them match.
Re: loading data in table by using sql loader [message #311438 is a reply to message #311437] Fri, 04 April 2008 08:50 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
i tried it with following but still not working
because second is missing
DOB TIMESTAMP "YYYY-MM-DD HH24:MI
Re: loading data in table by using sql loader [message #311440 is a reply to message #311435] Fri, 04 April 2008 08:55 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
The fix is to make them match.
dash characters are not the same as slash characters.
Re: loading data in table by using sql loader [message #311466 is a reply to message #311435] Fri, 04 April 2008 10:13 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
60 posts and still not formatted.
Don't worth an answer.

Regards
Michel

[Updated on: Fri, 04 April 2008 10:14]

Report message to a moderator

Previous Topic: DIRECT PATH SQLLOADER
Next Topic: Problem in Import & Export
Goto Forum:
  


Current Time: Sun Dec 04 20:26:24 CST 2016

Total time taken to generate the page: 0.27576 seconds