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: SCN doesn't increment after DROP TABLE

Re: SCN doesn't increment after DROP TABLE

From: <kal121_at_my-deja.com>
Date: 2000/05/30
Message-ID: <8h0qqf$ge2$1@nnrp1.deja.com>#1/1

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

Original text of this message

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