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:
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
if you try to acces the database from client you also need to change/add the NLS_DATE_FORMAT at the client's registry.
Thank you for providing such a good link on this site...
Database Management Applications.
Glad to help
Click Here to Expand Forum to Full Width