Re: Roll Oracle 7.3.4 SYSDATE forward

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Tue, 27 Jul 1999 22:52:24 -0400
Message-ID: <379E7067.3A1A46B@bigfoot.com>

I'd like to repost that last question - how will fixed date affect archiving?

Eric San Andres wrote:

> 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 Tue Jul 27 1999 - 21:52:24 CDT