Re: Renaming column of CLOBs

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 08 Jun 2006 20:55:29 +0200
Message-ID: <8ksg82p9fcglp5940lnevea6haov9crmh2@4ax.com>

On 8 Jun 2006 10:27:43 -0700, "Bruce C. Miller" <bm3719_at_gmail.com> wrote:

>I have a table with a column of CLOBs that I want to rename. I can
>create the new column of CLOB type, but doing an UPDATE and SET on the
>new and old columns doesn't copy the data over properly. I guess I need
>to use the DBMS_LOB.COPY function, but I am not sure how to use this on
>a full column of data.
>
>Seems like a simple problem, but I haven't been able to find the answer
>online yet.

Why do you want to rename columns and does a view on top of the affected table not suffice?

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Jun 08 2006 - 13:55:29 CDT