Database Administration (MOSC)

MOSC Banner

ORA-02097 when setting max_string_size=extended

edited Mar 16, 2019 5:00AM in Database Administration (MOSC) 5 commentsAnswered

I tried to set max_string_size=extended on my Oracle XE 18c Windows Edtn. I did it following way and got

C:\oracle\product\18.0.0\dbhomeXE\bin>sqlplus /nolog

SQL*Plus: Release 18.0.0.0.0 - Production on Fri Mar 8 18:41:10 2019

Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

SQL> connect / as sysdba

Connected.

SQL> PURGE DBA_RECYCLEBIN;

DBA Recyclebin purged.

SQL> SHUTDOWN IMMEDIATE;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> STARTUP UPGRADE;

ORACLE instance started.

Total System Global Area 1610609384 bytes

Fixed Size                  9028328 bytes

Variable Size             520093696 bytes

Database Buffers         1073741824 bytes

Redo Buffers                7745536 bytes

Database mounted.

Database opened.

SQL> ALTER SYSTEM SET max_string_size=extended;

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