[thesite] problems copying a LONG column in oracle

[jeff]

rudy,

:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: rudy
:
: this is directed to the oracle gurus
: (adam/tcm614ce?  dan?  anybody?)
:
: we have a table with a LONG column that
: we need to migrate to a new table
:
: we've done this once (see below for similar
: procedure)
:
: dan, can you remember why we wanted to go
: from LONG to CLOB?
:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

that's an important question.  i think we found during codefest2.0 that
moving the data to a CLOB didn't give us any advantages, hindering us in
some aspects even.

thanks,

.jeff

name://jeff.howden
game://web.development
http://www.evolt.org/
mailto:jeff at members.evolt.org