Re: Renaming column of CLOBs

Brian Peasland wrote:
> Bruce C. Miller 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 not issue the following:
>
> ALTER TABLE table_name RENAME COLUMN old_name TO new_name;

Thanks :) I apparently got led down the wrong path by documentation suggesting that I had to perform this task through the DBMS_LOB package. Received on Fri Jun 09 2006 - 07:11:21 CDT