RE: Change sysdate in database to a future date

From: Hallas John <John.Hallas_at_btcellnet.net>
Date: Fri, 07 Dec 2001 01:03:18 -0800
Message-ID: <F001.003D734B.20011207002520@fatcity.com>

Or use the init.ora parameter FIXED_DATE to set the database time only. John

-----Original Message-----
From: kranti pushkarna [mailto:kranti_pushkarna_at_staarship.com] Sent: 07 December 2001 04:30
To: Multiple recipients of list ORACLE-L Subject: RE: Change sysdate in database to a future date

change the date of the system on which the database resides

-----Original Message-----
Sent: Friday, December 07, 2001 9:15 AM
To: Multiple recipients of list ORACLE-L

Hi Gurus,

I need to change the sysdate in the database to a future date. Does anyone know the command to do it ? Please advise. Thanks.

Regds,
New Bee
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: CHAN Chor Ling Catherine (CSC)
  INET: clchan_at_nie.edu.sg

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: ListGuru_at_fatcity.com (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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: kranti pushkarna
  INET: kranti_pushkarna_at_staarship.com

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: ListGuru_at_fatcity.com (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).

---

This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately.

---

Received on Fri Dec 07 2001 - 03:03:18 CST