Re: Roll Oracle 7.3.4 SYSDATE forward

Pete Sharman wrote:

> Eric
>
> SYSDATE is derived from the OS date. The easiest way to change it is at
> the OS level.
>
> HTH.
>
> Pete
>
> 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.
>
> --
> Regards
>
> Pete
>
> ------------------------------------------------------------------------
>
> Pete Sharman <psharman_at_us.oracle.com>
> Project Manager
> Oracle University, Consulting and Vertical Education
> Oracle Corporation
>
> Pete Sharman
> Project Manager
> Oracle University, Consulting and Vertical Education
> Oracle Corporation
> 500 Oracle Parkway M/S OPL-B1024
> Redwood Shores
k£(
> California E%20DBA%20Handbook%20%20%3D%0D%0A%09%3D0D%3D0A%3D%0D%0AWork: +1.650.607.0109
> 94065
> USA
> **** The statements and opinions expressed here are my **** **** own and do not necessarily represent those of **** **** Oracle Corporation. **** "Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook "Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA
> Additional Information:
> Last Name Sharman
> First Name Peter
> Version 2.1

hello,
we have multiple databases.. and we do not want other databases to be affected

thanks Received on Thu Jul 22 1999 - 16:36:51 CDT