Re: equiv to dbms_flashback.get_system_change_number() of 9i at 8.1.5

"Frank Zaum" <FrankZaum_at_yahoo.de> wrote in message news:e98147be.0210150958.5c7c8879_at_posting.google.com...
> Hi experts,
>
> I am wondering if theres an equivalent to this 9i select statement at 8i:
>
> select dbms_flashback.get_system_change_number from dual;
>
> or do i have to look up the redo logs for that information ?
>
>
> i am also wondering if there are other "events" that increase the scn
except
>
> alter system checkpoint,
> alter system switch logfile,
> commit.
>
> i could not find this info in the FAQ, nor could i find it in the
documentation.
> and, could anyone explain to me why the scn is always increased by at
least 2 ?
>
> thanks,
>
> Frank Zaum,
>
> Salzgitter

Obvious questions have obvious answers. Flashback query is a new 9i feature. It simply doesn't exist in 8i. PERIOD.
The "event" which increments the scn is called a transaction. IIRC a commit or a rollback will also increase the SCN

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address