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!

Changing NLS_LENGTH_SEMANTICS in Oracle 10g

762591Jan 25 2011 — edited May 17 2011

Hi All,

I have to change the NLS_LENGTH_SEMANTICS of a oracle database from BYTE to CHAR. The procedure for this is as below :

1. Issue the following command
alter system set nls_length_semantics='CHAR' scope=both;
2. Restrat the database.

Will this change affect the existing data of the database? If no then, how to handle the effect of this change for the existing data on that database.

Please advice.

This post has been answered by Nicolas Gasparotto on Jan 25 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 14 2011

Added on Jan 25 2011

#general-database-discussions

9 comments

7,059 views