Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ALTER COLUMN VARCHAR2 SIZE FROM 3000 TO 32000

rock_1986Feb 16 2022

Dear Guru's
Want to increase the column size from 3000 TO 32000 by using alter statement.
In my db contains extended data types enabled.
alter table temp modify v_name varchar2(32000); getting error.
Please help on this.

Regards
Rocks

Comments
Post Details
Added on Feb 16 2022
18 comments
12,495 views