Home » Server Options » Multitenant » nls_database_parameters CDB and PDB (Oracle 12c on Windows 2012 R2)
nls_database_parameters CDB and PDB [message #644813] Wed, 18 November 2015 04:59 Go to previous message
sarrus
Messages: 5
Registered: November 2015
Junior Member
Can anyone explain why nls_database_parameters changes when creating PDB's?
My CDB shows :
NLS_RDBMS_VERSION;12.1.0.2.0 NLS_NCHAR_CONV_EXCP;FALSE NLS_LENGTH_SEMANTICS;BYTE NLS_COMP;BINARY NLS_DUAL_CURRENCY;$ NLS_TIMESTAMP_TZ_FORMAT;DD-MON-RR HH.MI.SSXFF AM TZR NLS_TIME_TZ_FORMAT;HH.MI.SSXFF AM TZR NLS_TIMESTAMP_FORMAT;DD-MON-RR HH.MI.SSXFF AM NLS_TIME_FORMAT;HH.MI.SSXFF AM NLS_SORT;BINARY NLS_DATE_LANGUAGE;AMERICAN NLS_DATE_FORMAT;DD-MON-RR NLS_CALENDAR;GREGORIAN NLS_NUMERIC_CHARACTERS;., NLS_NCHAR_CHARACTERSET;AL16UTF16 NLS_CHARACTERSET;AL32UTF8 NLS_ISO_CURRENCY;AMERICA NLS_CURRENCY;$ NLS_TERRITORY;AMERICA NLS_LANGUAGE;AMERICAN
When I create the a simple PDB, the nls_database_parameters shows:
NLS_RDBMS_VERSION;12.1.0.2.0 NLS_NCHAR_CONV_EXCP;FALSE NLS_LENGTH_SEMANTICS;BYTE NLS_COMP;BINARY NLS_DUAL_CURRENCY;Kr. NLS_TIMESTAMP_TZ_FORMAT;DD.MM.RRRR HH24.MI.SSXFF TZR NLS_TIME_TZ_FORMAT;HH24.MI.SSXFF TZR NLS_TIMESTAMP_FORMAT;DD.MM.RRRR HH24.MI.SSXFF NLS_TIME_FORMAT;HH24.MI.SSXFF NLS_SORT;NORWEGIAN NLS_DATE_LANGUAGE;NORWEGIAN NLS_DATE_FORMAT;DD.MM.RRRR NLS_CALENDAR;GREGORIAN NLS_NUMERIC_CHARACTERS;, NLS_NCHAR_CHARACTERSET;AL16UTF16 NLS_CHARACTERSET;AL32UTF8 NLS_ISO_CURRENCY;NORWAY NLS_CURRENCY;kr NLS_TERRITORY;NORWAY NLS_LANGUAGE;NORWEGIAN
I want the nls_database_parameters to be the same as the CDB, is there a way to do this?

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: How to gather various statistics with respect to CDB and PDB in 12c?
Next Topic: APEX in a multitenant database
Goto Forum:
  


Current Time: Mon Sep 21 00:33:52 CDT 2020