I have to unload a table into flat file .This table which is to be unloaded has a CLOB column.
Once unloaded into flat file-This flat file will be used to load data into another table having almost similar columns.
I did develop script like spooling this into a txt file :
where oid between 200 and 220
But when I use SQWL Loader to load data into another table having clob column it does not work.
I would appreciate if you could let me know, if there is another by which it could be done.
Thanks for all the help.