Re: How to 'unset' parameters ?

From: Peter van Rijn <p.vanrijnREMOVE_at_THISzhew.nl>
Date: Wed, 30 Oct 2002 15:33:32 +0100
Message-ID: <urvrj1j26nlu77@corp.supernews.com>

Hi Mark,

Almost!

From Metalink Note 16885.1:

<quote>
The FIXED_DATE parameter can be set in INIT.ORA or can be set dynamically using
the command ALTER SYSTEM SET FIXED_DATE = 'DD-MON-YY';

Unset FIXED_DATE by using the command:

     ALTER SYSTEM SET FIXED_DATE=NONE; </quote>

Peter

"Mark D Powell" <Mark.Powell_at_eds.com> schreef in bericht news:2687bb95.0210300555.17996702_at_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 - 08:33:32 CST