Re: Specifying the CLOBs in SQLLOADER control files

On 12 Aug 2006 22:23:07 -0700, VenkataRamesh.Kommoju_at_gmail.com wrote:

>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

Without

- the Oracle version
- the exact control file
- the exact syntax error

No one here will be capable to resolve your problem and you'd better not posted this three times.

--
Sybrand Bakker, Senior Oracle DBA