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!

ORACLE 18C MAX_STRING_SIZE=Extended works for sys only

KKloeserJan 9 2020 — edited Jan 9 2020

Hi,

I have an 18c XE database running and have changed the MAX_STRING_SIZE parameter successfully, following
https://docs.oracle.com/database/121/REFRN/GUID-D424D23B-0933-425F-BC69-9C0E6724693C.htm#REFRN10321

The weird thing is, I can create a table now

create table t (i varchar2(4001)) successfully as sys, but I can't as another user.
So the switch to MAX_STRING_SIZE=EXTENDED worked, utl32k.sql has been executed, but it just works for sys.

Any Ideas ?

Thanks

Klaus

Comments
Post Details
Added on Jan 9 2020
1 comment
460 views