-
Unload SQL Table data having CLOM Column
Hi guys,
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 :
SELECT
OID,',',
UNIQUE_CREATOR_ID,',',
ENTITY_ID_GLN,',',
INFO_PROVIDER_GLN,',',
SOURCE_DATA_POOL_GLN,',',
RECIPIENT_GLN,',',
GTIN,',',
DOCUMENT_CONTENT,',',..............CLOB Column
CREATION_USER_OID,',',
CREATION_DATE,',',
LAST_UPDATED_USER_OID,',',
LAST_UPDATED_DATE
FROM uccnet.IR_ROUTED_NOTIFICATION
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.
Bonny
-
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.
-
or use ctas if in same schema (or setup db links) saves on typing
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|