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: How do I konw the last time a table get modified.

Re: How do I konw the last time a table get modified.

From: Andrew Babb <andrewb_at_mail.com>
Date: Fri, 02 Apr 1999 08:53:15 +0800
Message-ID: <370414FB.CAB39F5D@mail.com>


That's correct.

Dong Tang wrote:

> So does it means the database will flip the status of the flag after a
> record inserted, modified or deleted from a table so that it will know this
> table should be exported or not ?
>
> Dong Tang
>
> Andrew Babb wrote in message <3702DBAD.E93730F7_at_mail.com>...
> >I don't believe that Oracle records the time, but it does have a flag on
> the
> >DBA_TABLES.BACKED_UP.
> >
> >Rgds
> >Andrew
> >
> >Dong Tang wrote:
> >
> >> Hi:
> >>
> >> As I am reading Oracle 8 Documantation about Export, I find out Oracle
> can
> >> do incremental and cumulative export, which is only exporting tables
> >> modified since last time export.
> >>
> >> That means somewhere in Oracle, the last modifed time in a time are
> >> recorded. Can any guru tell me where I can find this information?
> >>
> >> Please e-mail at tangd_at_ctcdist.com
> >>
> >> Thanks ahead
> >>
> >> Dong Tang
> >
Received on Thu Apr 01 1999 - 18:53:15 CST

Original text of this message

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