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 07:14 PM.
Can you try this
set termout off -- supress screen output
set colsep '|' -- column separator
set feedback off -- Turns off rows returned count display
set pagesize 0 -- remove column headings
set linesize 32767 -- total # characters displayed on one line
set long 32767 -- max width in bytes for LONG, CLOB, and NCLOB
set null '' -- text displayed for a null value (needed?)
select * from table
I think an ODBC application might also do it ..
Why can't you use odbc and SQL Server DTS to directly import the information from Oracle?
Click Here to Expand Forum to Full Width