Home » SQL & PL/SQL » SQL & PL/SQL » How to alter CLOB column to VARCHAR column?
How to alter CLOB column to VARCHAR column? [message #265350] Thu, 06 September 2007 02:55 Go to next message
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 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Sat Dec 03 04:01:02 CST 2016

Total time taken to generate the page: 0.11883 seconds