Unload SQL Table data having CLOM Column
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.
Re: Unload SQL Table data having CLOM Column
Have you looked at the DBMS_LOB package?
You should be able to use that package to parse the LOBS.
this space intentionally left blank
or use ctas if in same schema (or setup db links) saves on typing
Click Here to Expand Forum to Full Width