Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: CLOB to VARCHAR2 -- (ver 9i)

Re: CLOB to VARCHAR2 -- (ver 9i)

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 20 Sep 2006 00:13:33 +0200
Message-ID: <mqq0h25vb4bnrtpdgo3s443g16cgutotva@4ax.com>


On 19 Sep 2006 07:51:54 -0700, matt_at_mailinator.com wrote:

>
>thanks for the link tho. tom seems to answer the original post -- in
>9i, one *cannot* simply ALTER the table, one must go thru the process
>he describes -- adding a new column, copying data, dropping the
>original column. guess we both learned something new, huh?

I think you misinterpret it *exactly* the other way around. But I don't care if you know better.
Guess why I am so frustrated?

--
Sybrand Bakker, Senior Oracle DBA
Received on Tue Sep 19 2006 - 17:13:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US