Unload SQL Table data having CLOM Column
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Unload SQL Table data having CLOM Column

  1. #1
    Join Date
    Aug 2002
    Posts
    40

    Arrow 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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997

    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

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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
  •  



Click Here to Expand Forum to Full Width