Hi gurus,

Is is advisable to use long datatypes for large character fields in Oracle 8i?

If I LOB is advisable, how would I convert the existing long dataype field?

Also, how could I recreate a table having a long datatype?

Thanks!