RE: Changing sysdate[Scanned]

From: <Jorma.Vuorio_at_nokia.com>
Date: Wed, 04 Sep 2002 03:13:25 -0800
Message-ID: <F001.004C7248.20020904031325@fatcity.com>

RE: Constraints problem

It's date, not newdate. Check "man date".

-----Original Message-----
From: ext Karthikeyan S [mailto:skarthik@globalsw-in.com]
Sent: 04 September, 2002 13:28
To: Multiple recipients of list ORACLE-L
Subject: RE: Changing sysdate[Scanned]

Hi,

I am getting the error "newdate does not exist" when I tried $newdate '09042002 14:48:00' .

Is it the command I should use to change the sysdate in Solaris?

regards,

Karthik

-----Original Message-----
From: Naveen Nahata [mailto:naveen_nahata@mindtree.com]
Sent: Wednesday, September 04, 2002 12:53 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Changing sysdate[Scanned]

Change the System date, and restart the database.

-----Original Message-----
From: Karthikeyan S [mailto:skarthik@globalsw-in.com]
Sent: Wednesday, September 04, 2002 12:18 PM
To: Multiple recipients of list ORACLE-L
Subject: Changing sysdate

Hi,

Is it possible to change the sysdate? (Solaris 5.8, Oracle 8.1.7)

TIA.

K.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jorma.Vuorio_at_nokia.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).

Received on Wed Sep 04 2002 - 06:13:25 CDT