Re: alter system set fixed_date

From: FlaviusMaximus <member_at_dbforums.com>
Date: 27 Jul 2002 09:29:02 GMT
Message-ID: <3d4267de$1@news.usenetgateway.com>

Actually, if one looks at the database output of selecting from V$PARAMETER you can see that the default parameter for FIXED_DATE is not NONE but rather blank. Note here that for AUDIT_TRAIL the default value is NONE, but for FIXED_DATE there is none (hehe). Obviously plenty of room for confusion if all you do is read the manuals. Of course this says nothing about how to undo a change to FIXED_DATE back to none.

NAME VALUE ------------------------------ -----

O7_DICTIONARY_ACCESSIBILITY TRUE active_instance_count aq_tm_processes 0 archive_lag_target 0 audit_trail NONE ... fixed_date gc_files_to_locks global_context_pool_size global_names FALSE hash_area_size 1048576 hash_join_enabled TRUE ...

Consider the following:
SQL> select value from v$parameter where name = 'fixed_date';

VALUE

---

SQL> select sysdate from dual;

SYSDATE

---

26-JUL-02 SQL> alter system set fixed_date="01-jan-2001";

System altered.

SQL> select value from v$parameter where name = 'fixed_date';

VALUE

---

01-JAN-01 SQL> select sysdate from dual;

SYSDATE

---

01-JAN-01 SQL> alter system set fixed_date=none;

System altered.

SQL> select value from v$parameter where name = 'fixed_date';

VALUE

---

NONE SQL> select sysdate from dual;

SYSDATE

---

26-JUL-02

--
Posted via dBforums
http://dbforums.com

Received on Sat Jul 27 2002 - 04:29:02 CDT