Re: How to 'unset' parameters ?

Thanks !

Oracle documentation say "NULL" as default value, but it doesn't work. As Peter wrote, NONE is the correct default value.

"Peter van Rijn" <p.vanrijnREMOVE_at_THISzhew.nl> wrote in message news:urvrj1j26nlu77_at_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 Thu Oct 31 2002 - 04:07:55 CST