I'm trying to modify, at the instance level, the value of NLS_DATE_FORMAT, in order to meet my needs (I need the modification to be definitive, not limited to a session).
I've found some urls talking about modifying my DB specific init file "dbs/ora<SID_name>.init" by inserting the following line:
NLS_DATE_FORMAT = 'DD/MM/YY HH:MI AM'
but this was no help : after a shutdown and a restart the format stayed the same as the default one ; I verified it with the command:
select * from nls_database_parameters;
Though, the added line is indeed treated, since invalidating it by a modification causes the startup to fail.
Did I forget something? Or isn't it the way to do it with 8i?