Home » RDBMS Server » Server Utilities » Loading clob data in Table by using sql loader (10g 10.2.0.1.0 on linux 32 bit)
Loading clob data in Table by using sql loader [message #312220] Tue, 08 April 2008 04:22 Go to next message
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,

Re: Loading clob data in Table by using sql loader [message #312241 is a reply to message #312220] Tue, 08 April 2008 05:00 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What does the corresponding dat file contain for clob_filename?
Previous Topic: export import in oracle9i
Next Topic: imp triggers fails
Goto Forum:
  


Current Time: Thu Dec 08 06:02:25 CST 2016

Total time taken to generate the page: 0.12813 seconds