[thesite] problems copying a LONG column in oracle

Daniel J. Cody djc at starkmedia.com
Tue Apr 10 15:14:56 CDT 2001

Dean Mah wrote:

> > dan, can you remember why we wanted to go from LONG to CLOB?

> Oracle encourages migration from LONG to CLOB for the following
> reasons:

ya, what dean said :)

one big thing that dean mentioned is the allowance of random access to
data. the best example would be the ability to search article body's for
keywords rather than relying on verity.

that would also be really nice for seth's work on thetips and the new

More information about the thesite mailing list