Re: Roll Oracle 7.3.4 SYSDATE forward

From: Eric San Andres <ericsanandres_at_hotmail.com>
Date: Thu, 22 Jul 1999 14:37:24 -0700
Message-ID: <37978F14.19784BFC@hotmail.com>

tmgn wrote:

> You can add a line like
>
> fixed_date = '<Year 2000 date>'
>
> in the init.ora and bounce the database. All Further SQL queries
> selecting Sysdate will return the same date that you Specified as
> 'fixed_date' .
>
> But I am not sure of PL/SQL code referring sysdates..Probably you can
> create a Dumy table for storing the date and Select from it...
>
> -Thiru
>
> eric_peterson_at_maurices.inrg.com wrote:
>
> > We are in the midst of performing some final Y2K compliance testing.
> > Does anyone know if it is possible to roll SYSDATE on the database
> > forward without having to roll the system date on the hardware
> > forward? My thoughts are it is probably impossible. But, if anyone
> > has any info, please let me know.
> >
> > TIA
> > Eric Peterson
> > Programmer/Analyst DBA
> > Maurices Inc.
> > eric_peterson_at_maurices.inrg.com
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.

How will archiving work with fixed time? Received on Thu Jul 22 1999 - 16:37:24 CDT