nls_database_parameters CDB and PDB [message #644813] |
Wed, 18 November 2015 04:59 |
|
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?
|
|
|