Database Administration (MOSC)

MOSC Banner

Increase varchar2 length to beyond 4000

edited Apr 21, 2010 8:56PM in Database Administration (MOSC) 9 commentsAnswered
 I need to increase the one column size to beyond 4000 characters length.

Column type is varchar2

maximum size it may grow is 20000. I am getting the following error when i try to increase the size:

ORA-00910: specified length too long for its datatype

Could you please suggest me.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center