DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.