Re: How to 'unset' parameters ?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 30 Oct 2002 05:55:15 -0800
Message-ID: <2687bb95.0210300555.17996702@posting.google.com>

Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3DBEBCBC.3D8A7384_at_exesolutions.com>...
> Jaret Lafoudravecmonhnez wrote:
>
> > Is it possible to 'UNSET' a parameter set with 'alter system'
> >
> > For example, I set SYSDATE with "alter system set
> > FIXED_DATE='2002-10-29-15:25:00';"
> > How can I unset FIXED_DATE without restarting the database ?
> >
> > Ludovic
>
> Alter it back to its original value the same way you changed it.
>
> You don't mention a version ... but in 9i with an SPFILE the changes are
> not reset after bouncing the database.
>
> Daniel Morgan

I think the problem might be Jaret doesn't know what value to set fixed_date back to. I believe the default setting of fixed_date is null so:
" alter system set fixed_date = ''; " should do the trick.

HTH -- Mark D Powell -- Received on Wed Oct 30 2002 - 07:55:15 CST