Can someone help to provides answers to below:
1. I Display the contents of the V_$NLS_parameters for 2 database & found out 1 of db's NLS is not the same values esp the Language & Teritory.
Can i change the values of the NLS parameter in my database so that both db are consistent, if yes or no, will there have any impact of applications.
2. How do i change the values, cause it is merely a data dict view & not a table, can it be done via initialization parameters or alter session or how?
3. I also noticed that the values in the display contents of the V_$NLS_parameters are different when i view All Initialization Parameters in the instance
configuration using OEM console. Are these come from the same source of data? Do i have to make it consistent for both NLS values in Initialization
Parameters and V_$NLS_parameters.
4. May i know if the values in All Initialization Parameters can be changed? If yes, do i have to shutdown & start up database to make into effect.?
Hope to hear from u soon...SFF.