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?