-
hi guys,
i want to change the parameter nls_date_format.. I know i can do it with alter session. I can also do it by changing it in the registry.. Can i add the paramter in my pfile.. I tried doing that too. I added the parameter then restarted the database. But it is not working.. Any suggestions..
Thanks in advance..
When the going gets tough, the tough gets going
-
Should be fine:
http://otn.oracle.com/docs/products/...18.htm#2053228
Perhaps your client tool is overriding this with the value from the registry.
[Edited by TimHall on 01-24-2002 at 06:54 AM]
-
You need to change at registry and the pfile
NLS_DATE_FORMAT=
if you try to acces the database from client you also need to change/add the NLS_DATE_FORMAT at the client's registry.
-
Hi Tim,
Thank you for providing such a good link on this site...
Zahid
Oracle DBA
Computer Associates
Vancouver, Canada.
Mohammad Zahid
Software Developer
Database Management Applications.
Vancouver, Canada
E-mail: mzahid@shaw.ca
-
Glad to help
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|