Re: UNIX\Oracle 7

Check out the FIXED_DATE init.ora parameter. Per the Oracle documentation this parameter "Allows you to set a constant for SYSDATE in the format YYYY-MM-DD-HH23:MI:SS. Also accepts the default Oracle date format, without a time..... This parameter is useful primarly for testing."

That is how we changed dates within one Oracle test instance for Y2K testing.

"Michael R. Cook" wrote:

> I have a bit of a problem and I hope someone out there has a suggestion.
> It is primarially a UNIX\Oracle question. We are running Oracle 7 on
> DYNIX\ptx(R) 4.4.2. I need to find a way into fooling Oracle into using a
> date other than the system date. For example, I want Oracle to use the
> date of 00 as oposed to the system date of 99. This would allow for
> testing of Oracle based software (DB) without disrupting the other
> applications being run on the UNIX OS. Any suggestions? I have posted
> the question on multiple UNIX groups as well but with no avail...
>
> Michael Cook
> mrc26_at_columbia.edu

--
Linda Montgomery
Database Analyst
James Madison University
montgolh_at_jmu.edu Received on Tue Mar 23 1999 - 16:10:36 CST