OraFAQ Forum: SQL & PL/SQL » How to alter CLOB column to VARCHAR column?

Home » SQL & PL/SQL » SQL & PL/SQL » How to alter CLOB column to VARCHAR column?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to alter CLOB column to VARCHAR column? [message #265350]

Thu, 06 September 2007 02:55

soidamientrung
Messages: 2
Registered: September 2007
Location: HCM

Junior Member

I have a table, that has contained a lot of important data. In that table, CLOB column of any row is evaluated null.
I want to change data type of CLOB column to VARCHAR column.
Are there any way to do this?

[Updated on: Thu, 06 September 2007 07:42] by Moderator

Report message to a moderator

Re: How to alter CLOB column to VARCHAR column? Help me!!!! [message #265380 is a reply to message #265350]

Thu, 06 September 2007 04:06

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Create a new column of varchar2, copy data from clob to varchar2, drop clob column and rename varchar2 column.

Or use dbms_redefinition.

Regards
Michel

[Updated on: Thu, 06 September 2007 04:06]

Report message to a moderator

Previous Topic:	Not in Vs Not exists
Next Topic:	regarding index & partition.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 12:38:08 CST 2024