I would like to change NLS_DATE_FORMAT in props$ (which is the format oracle uses for export/import ).
init.ora and alter session set NLS_DATE_FORMAT are not doing it.
SQL> show parameter nls_date_format
NAME TYPE VALUE
----------------------------------- ----------- -----------
nls_date_format string MM/DD/YYYY
SQL> select sysdate from dual;
SYSDATE
----------
02/17/2003
1 select name, value$ from props$
2* where name='NLS_DATE_FORMAT'
SQL> /
NAME
------------------------------
VALUE$
------------------------------------------------
NLS_DATE_FORMAT
DD-MON-YY
How do I change NLS_DATE_FORMAT in props$?