need to increase the sizeof this column

[deo swaroop]

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

[Christophe Verré]

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

[deo swaroop]

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

[Christophe Verré]

You could use an NCLOB instead.

[deo swaroop]

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

[Christophe Verré]

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.

[Christophe Verré]

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

[deo swaroop]

Hi Christophe ,

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

Thanks.