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: Puring Ancient Scheme Objects

Re: Puring Ancient Scheme Objects

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sun, 01 Aug 2004 18:02:58 -0400
Message-ID: <pan.2004.08.01.22.02.56.263755@sbcglobal.net>


On Sun, 01 Aug 2004 10:54:37 -0700, Michael wrote:

> Hello,
>
> In analyzing an 8.17 database that has been in production for serveral
> years starting from Oracle version 6, how can I determine the last
> time a table was accessed or data in it changed?
>
> I'd like to remove any unused tables etc.
>
> If you have any other suggestions on purging ancient scheme objects
> please do.

Auditing on the particular object will do the trick.

-- 
A city is a large community where people are lonesome together.
Received on Sun Aug 01 2004 - 17:02:58 CDT

Original text of this message

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