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

Home -> Community -> Usenet -> c.d.o.server -> Re: What is mean [alter system set fixed_date = 'yyyy_mm_dd_hh24_mi_ss']

Re: What is mean [alter system set fixed_date = 'yyyy_mm_dd_hh24_mi_ss']

From: UniSoft <oracle_at_unisoft.dp.ua>
Date: 28 May 1998 13:20:44 +0300
Message-ID: <AALFIRri61@unisoft.dp.ua>


26-May-98 03:37 saropani_at_my-dejanews.com wrote:
:>In article <x70UZg4h9GA.249_at_newsfeed.netsgo.com>,
:> "À̱¤¿ì(Lee,KwangWoo)" <leewin_at_netsgo.com> wrote:
:>>
:>> What is mean [alter system set fixed_date = 'yyyy_mm_dd_hh24_mi_ss'] ?
:>> What is mean [alter system set gc_defer_time = integer] ?
:>>
:>> Lee,KwangWoo (leewin_at_netsgo.com)
:>>
:>>
:>
:>Hi Lee,
:>
:>There is a Initialization parameter FIXED_DATE. If you set this parameter to
:>some date value, then all your 'SELECT SYSDATE.....' query will return the
:>date you set, rather than the current date. This parameter is useful when
:>debugging. I beleive the same happens with the 'ALTER SYSTEM SET FIXED_DATE..'
:>
:>Regards,
:>Saravanan (saro_at_psoux141.sgp.hp.com)
:>
:>
:>
:>
:>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
:>http://www.dejanews.com/ Now offering spam-free web-based newsreading

What Oracle version? I use 7.3.3 and can't find nothing like you wrote above

Eugene Received on Thu May 28 1998 - 05:20:44 CDT

Original text of this message

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