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!

alter system set nls_length_semantics

XenofonMay 27 2010 — edited May 27 2010
Hi all,

my question concerns the scope in the change of NLS_LENGTH_SEMANTICS can be performed.

The 10gR2 documentation only the

"Modifiable ALTER SESSION"

But what about altering the system and making your own setting to default for all sessions? With which scope?

I tried

alter system set nls_length_semantics='CHAR';
alter system set nls_length_semantics='CHAR' scope=spfile;
alter system set nls_length_semantics='CHAR' scope=both;

None had really any effect. Do I have to bounce the database?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2010
Added on May 27 2010
#general-database-discussions
2 comments
22,336 views