Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003

    Red face Unanswered: Spooling data from a clob table

    Hi all,
    I am trying to spool data from a clob table as follows:
    set long 10000
    spool TDETAIL.dat
    select x from clob_table order by id;
    spool off
    where x is a CLOB datatype.
    in the spooled file TDETAIL.dat, the data is split into 80 byte lengths. So one row is split into several lines . Is there a way the output can be spooled without the extra new-line characters ? I need to use this file as input to SQL Loader.

  2. #2
    Join Date
    Nov 2002
    why not creating a database link for the instance you want to run sqlldr for?

    and then insert into table ... as select lobobject from table@link

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts