RE: Changing sysdate - Problem resolved
Title: RE: Constraints problem Hi Gurus, Thanks a lot for your help. The problem is resolved now. regards, Karthik -Original Message-From: Karthikeyan S [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 04, 2002 2:48 AMTo: Multiple recipients of list ORACLE-LSubject: Changing sysdate Hi, Is it possible to change the sysdate? (Solaris 5.8, Oracle 8.1.7) TIA. K.
RE: Changing sysdate
Title: RE: Constraints problem I remember a Y2K testing parameter for setting the database date. It still might work. Search for FIXED_DATE to see what NLS date format to use. HTH Tony Aponte -Original Message-From: Karthikeyan S [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 04, 2002 2:48 AMTo: Multiple recipients of list ORACLE-LSubject: Changing sysdate Hi, Is it possible to change the sysdate? (Solaris 5.8, Oracle 8.1.7) TIA. K.
Re: Changing sysdate
Of course. Conventional way is to synchronize system date and time with some public time server. :-) JP On Wednesday 04 September 2002 08:48, you wrote: Hi, Is it possible to change the sysdate? (Solaris 5.8, Oracle 8.1.7) TIA. K. -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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).
RE: Changing sysdate
Title: RE: Constraints problem Change the System date, and restart the database. -Original Message-From: Karthikeyan S [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 04, 2002 12:18 PMTo: Multiple recipients of list ORACLE-LSubject: Changing sysdate Hi, Is it possible to change the sysdate? (Solaris 5.8, Oracle 8.1.7) TIA. K.
RE: Changing sysdate[Scanned]
Title: RE: Constraints problem Hi, I am getting the error "newdate does not exist" when I tried $newdate '09042002 14:48:00'. Is it the commandI 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 PMTo: Multiple recipients of list ORACLE-LSubject: 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 PMTo: Multiple recipients of list ORACLE-LSubject: Changing sysdate Hi, Is it possible to change the sysdate? (Solaris 5.8, Oracle 8.1.7) TIA. K.
RE: Changing sysdate[Scanned]
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:28To: Multiple recipients of list ORACLE-LSubject: 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 commandI 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 PMTo: Multiple recipients of list ORACLE-LSubject: 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 PMTo: Multiple recipients of list ORACLE-LSubject: Changing sysdate Hi, Is it possible to change the sysdate? (Solaris 5.8, Oracle 8.1.7) TIA. K.
Re: Changing sysdate[Scanned]
It is better to use ntpdate. JP On Wednesday 04 September 2002 12:28, you wrote: 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- Sent: Wednesday, September 04, 2002 12:53 PM To: Multiple recipients of list ORACLE-L Change the System date, and restart the database. -Original Message- Sent: Wednesday, September 04, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Hi, Is it possible to change the sysdate? (Solaris 5.8, Oracle 8.1.7) TIA. K. -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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).