Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SCN doesn't increment after DROP TABLE
Hmmm, maybe I am looking in the wrong dictionary view -
OK - this is a dumb question - but which dictionary table keeps track of current scn's? I can't seem to find it even when I query dict_columns.
Thanks
In article <392EEDBB.14632CB_at_workmail.com>,
johnny_chan <johnny.chan_at_workmail.com> wrote:
>
>
> kal121_at_my-deja.com wrote:
>
> > How come DROP TABLE statements aren't recorded in the archive logs?
Or
> > rather, why isn't the SCN number incrementing after I do a DROP
TABLE?
>
> i see the SCN incrementing as expected after a drop table
command...where
> exactly are you not seeing the SCN incrementing?
>
> jc
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue May 30 2000 - 00:00:00 CDT