NLS_DATE_FORMAT issues
Neo-bFeb 10 2011 — edited Feb 10 2011Hello All,
I am using Oracle 11g R2.
i was importing a dump and i got some errors because of the NLS_DATE_FORMAT, so i change it to YYYYMMDD using the below command:
alter system set nls_date_format= 'YYYYMMDD' scope = spfile; and i restart it the db in order the change can take place.
and then i re-import it my dump and every thing went OK.
but when i am selecting: select * from v$nls_parameters;
the value of NLS_DATE_FORMAT is not changing to 'YYYYMMDD' it is 'DD-MON-RR.
This issue is appearing on 2 databases running on two servers and i am not able to check if the changes take place.
Regards,