[thesite] problems copying a LONG column in oracle

[Daniel J. Cody]

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:
{snip}

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
harvester