Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What is mean [alter system set fixed_date = 'yyyy_mm_dd_hh24_mi_ss']
In article <AALFIRri61_at_unisoft.dp.ua>,
oracle_at_unisoft.dp.ua wrote:
>
> 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
>
>
Hi Eugene,
I am also using Oracle7 Release 7.3.3.0.0. Please check v$parameter or from SVRMGRL 'show parameter fixed_date'. I have double-checked it.
Regards,
Saravanan
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu May 28 1998 - 21:12:50 CDT