| loading data in table by using sql loader [message #311435] |
Fri, 04 April 2008 08:45  |
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 |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
