Export table with CLOB field
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Export table with CLOB field

Threaded View

  1. #1
    Join Date
    Mar 2003

    Export table with CLOB field

    I need to export a table to a flat file. I've been trying 'exp' and SPOOL in sqlplus, but I'm having issues because of the presence of a CLOB field in the table. There are garbage characters all over the place in the file even though the output looks fine in sqlplus. I need to create the flat file in order to import into a MS SQL Server database table (substituting TEXT data type in MS SQL for CLOB). So, I need a way to export the table from Oracle into some delimited flat file. Oracle 8.1.7. Any ideas?
    Last edited by shadrap; 03-22-2003 at 06:14 PM.

Posting Permissions

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

Click Here to Expand Forum to Full Width