Database Administration (MOSC)

MOSC Banner

Increasing the Maximum Size of VARCHAR2, NVARCHAR2, and RAW Columns in an Oracle RAC Database?

edited May 18, 2016 10:51AM in Database Administration (MOSC) 5 commentsAnswered ✓

In document of Oracle, it explained

To increase the maximum size of VARCHAR2, NVARCHAR2, and RAW columns in an Oracle RAC database:

Shut down all of the Oracle RAC database instances, except one.
Restart the Oracle RAC database instance in UPGRADE mode.
Change the setting of MAX_STRING_SIZE to EXTENDED.
Run the rdbms/admin/utl32k.sql script in the Oracle RAC database instance. You must be connected AS SYSDBA to run the script.
Restart all Oracle RAC database instances in NORMAL mode.
Run the rdbms/admin/utlrp.sql script to recompile invalid objects. You must be connected AS SYSDBA

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