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

Thread: How to convert column datatype?

  1. 06-13-2002, 10:08 AM #1
    orakin
    orakin is offline Junior Member
    Join Date
    May 2002
    Posts
    2

    Red face

    I have a table and one of it's columns are "long" and I want to convert it to "varchar2" and maintain the data.

    Help.

    I've tried SELECT - INSERT INTO but got an error stating the illegal use of the LONG field.

    Can someone give me an idea...I'm new to ORACLE.

    Orakin
    Reply With Quote Reply With Quote
  2. 06-13-2002, 10:30 AM #2
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Oracle recommend all users to change the application and
    start using CLOB/BLOB data type instead of LONG/LONG RAW.

    See metalink Doc 158214.1
    Reddy,Sam
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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