Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: server sysdate manipulation
In article <1998Jun14.202956.51176_at_ludens>,
seci_at_ludens.elte.hu wrote:
>
> hello,
> In article <2465A05A033BD111969500805F4BEF5B0BCC9D_at_SULACO>, Cees Van Tilburg
<ctilburg_at_ortec.nl> writes:
> > I need to test a complex application on a Oracle 7.3/Unix server.
> > To be able to complete the test in a reasonable time I must be able
> > to manipulate the systemdate in order to trigger some events which
> > otherwise would require weeks of waiting.
> >
> > Since there are other applications running on the unix-server I it is
> > not allowed
> > to simply change the systemdate of the server. So I must have something
> > which
> > manipulates the sysdate for only one specific user or user-proces.
> >
> > Is this possible under Unix or ORACLE? Or do I have to specify a
> > function which
> > increases/decreases the sysdate by a number of days and use this instead
> > of the
> > sysdate function?
> >
> > We are still in analysis stage so we have the freedom to choose whatever
> > solution without regard
> > of existing code.
> >
> implement a packaged (or a simple) function that simple returns the sysdate in
> the production system and returns whatever is in a specific table in the test
> system [so you can easily manipulate the "system" date during test].
> this will work.
>
> > Please post whatever solution comes to mind, I will repost a resume.
> >
> > regards,
> >
> > Cees van Tilburg
> > ctilburg_at_spamortec.nl (remove...spam)
> >
> HTH
> peter
>
Hi Cees,
At database level you can set the value of sysdate to a fixed value. This can done by just setting the FIXED_DATE parameter in the initSID.ora file.
See if it helps.
Regards,
Saravanan
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Jun 16 1998 - 04:37:04 CDT