Skip to Main Content

Cloud Platform

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!

Setting NLS_LANGUAGE and NLS_TERRITORY at database level

User_QHX76Apr 12 2017 — edited Apr 26 2017

Hi everyone,

I need to set NLS_LANGUAGE and NLS_TERRITORY at database level (those from nls_database_parameters). We read that that we can set up those parameters only at database installation time (unlike NLS parameters at instance and session level), is it true?

During Oracle Database Cloud installation wizard I didn't found any option to change language or NLS parameters of database and now for example NLS_LANGUAGE is AMERICAN not CROATIAN and NLS_TERRITORY is AMERICA not CROATIA.  This parameters at database level are important to us because Oracle optimizer uses them. How can we achieve this?

Regards,

Ivan

This post has been answered by Sailaja-Oracle on Apr 24 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 24 2017
Added on Apr 12 2017
8 comments
13,002 views