need to increase the sizeof this column

Hi All,

We are using oracle -10G. We have a table CONF and a particular column is defined as VALUE NVARCHAR2(1024) . I need to increase the sizeof this column as it have to handle more data in future.

Please suggest.

Regards,
deo swaroop

ALTER TABLE CONF MODIFY VALUE NVARCHAR2(XXXX) doesn't work ?

we are targeting to insert some 1 lakh caracters. nvarchar2 supports only till 2000.

You could use an NCLOB instead.

Will we be able to modify even when there is data existing in the table? any other data type?

deo swaroop wrote:Will we be able to modify even when there is data existing in the table? any other data type?

I think so. Backup your table, and use an "alter table" like the one above.

Mmmh, after some thought, not sure you can. Try it, but if you can't, you can do this instead :
1. Create a new NCLOB column
2. Copy the content of the old column to the new column using UPDATE
3. Drop the old column
4. Rename the new column

Hi Christophe ,

I really appreciate your help and quick response. Let me iterarte throuth the possible options.

Thanks.