Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Specifying the CLOBs in SQLLOADER control files

Specifying the CLOBs in SQLLOADER control files

From: <VenkataRamesh.Kommoju_at_gmail.com>
Date: 12 Aug 2006 22:23:07 -0700
Message-ID: <1155446586.916884.269630@74g2000cwt.googlegroups.com>


hi,

i have a column of length 4211 from the DB2 which is already loaded into the datafile in EBCDIC format.

I am loading the data into the oracle tables using the charcter set clause from EBCDIC to ASCII.

when i specify a column with CLOB datatype i am getting a syntax error.

Please let me know how to load a colunm with CLOB data type in the oracle databaase tabel.

thanks
Ramesh Received on Sun Aug 13 2006 - 00:23:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US