Re: Reset 'fixed_date

Hi,

you can either bounce the database (not good) or do

SQL> ALTER SYSTEM SET FIXED_DATE=NONE; here is an example output showing this working.      

SQL> select to_char(sysdate,'DD-MON-YYYY') FROM DUAL;

TO_CHAR(SYS                                                                                         
-----------                                                                                         
20-NOV-2001                                                                                  

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

NAME                                                                                                
----------------------------------------------------------------                                    
VALUE                                                                                               
------------------------------------------------------------------------
----------------------------
fixed_date                                                                                          
                                                                                                    
                                                                                                    

SQL> alter system set fixed_date='2001-10-02';

System altered.

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

NAME                                                                                                
----------------------------------------------------------------                                    
VALUE                                                                                               
------------------------------------------------------------------------
----------------------------
fixed_date                                                                                          
02-OCT-01                                                                                           

SQL> alter system set fixed_date=none;

System altered.

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

NAME                                                                                                
----------------------------------------------------------------                                    
VALUE                                                                                               
------------------------------------------------------------------------
----------------------------
fixed_date                                                                                          
NONE                                                                                                
                                                                                                    

SQL> select to_char(sysdate,'DD-MON-YYYY') FROM DUAL;

TO_CHAR(SYS                                                                                         
-----------                                                                                         
20-NOV-2001                                                                                         

SQL> spool off

HTH
Pete Finnigan
www.pentest-limited.com

In article <OblK7.31138$xS6.51964_at_www.newsranger.com>, mromka_at_yahoo.com writes
>Hi all,
>how to reset 'fixed_date' parameter to its default (empty) value?
>Thanks.
>
>

-- 
Pete Finnigan
IT Security Consultant
PenTest Limited

Office  01565 830 990
Fax     01565 830 889
Mobile  07974 087 885

pete.finnigan_at_pentest-limited.com

www.pentest-limited.com