| Loading clob data in Table by using sql loader [message #312220] |
Tue, 08 April 2008 04:22  |
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
|
Senior Member |
|
|
I am trying to load data (including clob field) in Table by using SQL loader, i got csv file and i am doing it by using control file
Following are the contents of control file
LOAD DATA
APPEND
INTO TABLE schema.c1
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(
SEARCH INTEGER EXTERNAL,
clob_filename FILLER CHAR(2000),
text LOBFILE(clob_filename) TERMINATED BY EOF,
DATE_A TIMESTAMP "YYYY-MM-DD HH24:MI:SS.FF",
SURNAME CHAR,
SECONDNAME CHAR,
TITLE CHAR,
DOB TIMESTAMP "YYYY-MM-DD HH24:MI:SS.FF",
)
Field by the name of TEXT is having 4000 characters, all data is loaded except CLOB field (text) and when i am looking at log it is showing following 10 errors with field contents because thre are 10 records to load.
SQL*Loader-502: unable to open data file 'it consist of field contents'
SQL*Loader-553: file not found
SQL*Loader-509: System error: No such file or directory
Regards,
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
