Long Raw and Blobs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Long Raw and Blobs

  1. #1
    Join Date
    Apr 2001

    Long Raw and Blobs


    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


    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.


    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