Set the environment variables for your shell. You don't have to change your database
settings.
e.g. (in ksh)
NLS_DATE_FORMAT=YYYYMMDDHH24MISS
export NLS_DATE_FORMAT
NLS_LANG=AMERICAN_AMERICA.WE8DEC
export NLS_LANG
Jay
>>> "SARKAR, Samir" <[EMAIL PROTECTED]> 04/08/02 01:44PM >>>
Jay,
Thanks so much for ur help. Could u please tell me whether I shall have to
set the NLS_DATE_FORMAT and NLS_LANG in the parameter file of the auxiliary
db alone or on
the target db (the main prod db) as well ???
Regards,
Samir
Samir Sarkar
Oracle DBA
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028
Fax : +44 (0) 115 - 957 6018
-----Original Message-----
Sent: 08 April 2002 18:28
To: [EMAIL PROTECTED]; SARKAR, Samir
You need to change this line
set until time 'to_date(''20-MAR-2002
20:00:00'',''DD-MON-YYYYHH24:MI:SS'')';
to
set until time '20020320200000';
This is bug 1887009. This isn't fixed until 9.0.2.
You must set
NLS_DATE_FORMAT=YYYYMMDDHH24MISS (or your favorite date format)
and
NLS_LANG= (whatever your nls lang is for the database)
I learned the hard way, that if you don't set NLS_LANG, then NLS_DATE_FORMAT
is ignored (at least in 8.1.7 on Tru64).
Don't forget to shutdown your auxiliary db, delete it's files, then start it
up again, NOMOUNT.
Jay
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jay Hostetter
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
