Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Setting NLS_LANGUAGE and NLS_TERRITORY at database level — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Setting NLS_LANGUAGE and NLS_TERRITORY at database level

Received Response
27
Views
8
Comments
edited Apr 26, 2017 7:00AM in Database 8 comments

Summary

Setting NLS_LANGUAGE and NLS_TERRITORY at database level

Content

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!