| NLS_DATE_FORMAT [message #153028] |
Wed, 28 December 2005 08:27  |
bahy91
Messages: 91
Registered: September 2005
Location: Amsterdam
|
Member |
|
|
Hi,
I am quit new with Oracle and look for the information how to set the NLS_DATE_FORMAT? to DD-MON-YYYY HH24.MI.SS not only for a session but for the whole db, so that all applications have this setting.
Trying to "alter system" via commandline or enterprise manager failed with ORA-02096 specified initialization parameter is not modifiable with this option
?
Where else can I set this to make it persistent?I want to use this new setting in RMAN
Your answers are highly welcome
|
|
|
|
| Re: NLS_DATE_FORMAT [message #153029 is a reply to message #153028] |
Wed, 28 December 2005 08:31  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
For RMAN, set this in your OS Environment, before invoking rman or script it along with.
like in unix
export NLS_DATE_FORMAT='MON DD YYYY HH24:MI:SS'
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
