Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to 'unset' parameters ?

How to 'unset' parameters ?

From: Jaret Lafoudravecmonhnez <toto_at_toto.com>
Date: Tue, 29 Oct 2002 15:30:58 +0100
Message-ID: <apm5fo$7lm$1@reader1.imaginet.fr>


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 Received on Tue Oct 29 2002 - 08:30:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US