DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Long Raw and Blobs

  1. #1
    Join Date
    Apr 2001
    Posts
    55

    Long Raw and Blobs

    Hi...

    Does anyone know how i can convert existing Long Raw datatype records to be Blobs.

    I'm unsure of the syntax and can't seem to find it anywhere.

    Thanks in Advance

  2. #2
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Solution

    Hi ,

    In Oracle8i a LONG column could be converted to a LOB using the TO_LOB() function.

    One of the restrictions on that use was it could not be used to convert a column in an existing table , only during the creation of a new table.

    In Oracle9i this conversion is possible using the ALTER TABLE with MODIFY syntax:

    Column content is currently a LONG
    ==================================

    ALTER TABLE documents MODIFY (content CLOB);

    Column content is currently a LONG RAW
    ======================================

    ALTER TABLE executables MODIFY (content BLOB);

    This syntax can only be used for the conversion of LONG and LONG RAW columns.

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

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