AW: SCN number and time

Hi KG,

thanks for your reply. But your solution only works with 9i, right. What about 8i?

Thanks,
Helmut

> -----Ursprüngliche Nachricht-----
> Von: K Gopalakrishnan [mailto:kaygopal_at_yahoo.com]
> Gesendet: Dienstag, 27. Mai 2003 12:40
> An: Multiple recipients of list ORACLE-L
> Betreff: Re: SCN number and time
>
>
> Hi,
>
> Have a look at SMON_SCN_TIME table. Note that this table is
> owned by SYS and used for FLASHBACK queries.
>
> KG
>
>
> =====
> Have a nice day !!
> ------------------------------------------------------------
> Best Regards,
> K Gopalakrishnan,
> Bangalore, INDIA.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: K Gopalakrishnan
> INET: kaygopal_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB
> ORACLE-L (or the name of mailing list you want to be removed
> from). You may also send the HELP command for other
> information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daiminger, Helmut
  INET: Helmut.Daiminger_at_KirchGruppe.de

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).