RE: Changing sysdate[Scanned]

[Jorma . Vuorio]

Title: RE: Constraints problem

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

 

-----Original Message-----
From: ext Karthikeyan S [mailto:[EMAIL PROTECTED]]
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:[EMAIL PROTECTED]]
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:[EMAIL PROTECTED]]
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.