Re: Last time table updated

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 25 May 2001 18:22:47 +0200
Message-ID: <tgt1imdt15l8cc@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 - 11:22:47 CDT