Skip to Main Content
Forums

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

how to increase the datatype size varchar2(4000) to varchar2(32000)

user-hnxupMar 16 2023 — edited Mar 16 2023

Hi all,

Actually my current data base column size varchar2( 4000). i want to increase the datatype size varchar2(32000).

please help me any one urgent need for this problem.

present datatype : coulumn varchar2(4000)

requreied datatype:column varchar2(32000)

Error starting at line : 16 in command -
alter table sample modify sample_name varchar2(32000)
Error report -
ORA-14691: Extended character types are not allowed in this table.
14691. 00000 - "Extended character types are not allowed in this table."
*Cause: An attempt was made to create VARCHAR2 or NVARCHAR2 columns
larger than 4000 bytes, or a RAW column larger than 2000 bytes,
in a cluster, clustered table or index-organized table.
Action: Correct the statement and reenter.

Comments

Post Details

Added on Mar 16 2023
4 comments
47 views