Re: Last time table updated

This situation is a little bit more complicated than that. I only want to do exports for selected users and only when they've changed something in their schema (which might be only monthly or quarterly). We have a 2T+ database with some tables being exported and, for tables that are totally refreshed, we're keeping the load files. We're also running in nonarchivelog mode. I can't do "full" exports and I can't keep a bunch of incrementals either.

I'm familar with Oracles docs as well as export and rman and was just looking for a piece of information that I think is "somewhere" in the dictionary. I'm hoping that someone else knows "where".

Thanks for your input anyway!

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tgt1imdt15l8cc_at_beta-news.demon.nl...
>
> "Jeff Schott" <jschott_at_schottconsulting.com> wrote in message
> news:FVuP6.3406$lP5.1939684_at_news1.rdc2.pa.home.com...
> > I need to know the last time a table was updated for our backup &
 recovery
> > plan. I really don't want to turn on auditting.
> >
> > I'm thinking that the last time a table (or perhaps a segment) was
 updated
> > needs to be somewhere in the dictionary for the Incremental exports to
 work.
> > I just can't seem to find it no matter where I look.
> >
> > Does anyone else know?
> >
> > Thanks,
> > Jeffrey Schott, Schott Consulting Company
> >
> >
>
> Use incremental exports or incremental backup as available in RMAN and
 don't
> try to invent what Oracle has already invented for you and especially: try
> to read the Oracle docs on this topic. They're not provided for nothing!!
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
>
>
Received on Fri May 25 2001 - 12:36:12 CDT