Re: How to 'unset' parameters ?

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 29 Oct 2002 16:52:14 GMT
Message-ID: <3DBEBCBC.3D8A7384@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 Received on Tue Oct 29 2002 - 10:52:14 CST