c wrote:
> Rene Nyffenegger <rene.nyffenegger_at_gmx.ch> wrote in message news:<slrncm8tqj.3tk.rene.nyffenegger_at_zhnt60m34.netarchitects.com>...
>
>>In article <250e5e6c.0410061250.3f69c474_at_posting.google.com>, c wrote:
>>
>>>We need to identify old unused tables and wondering if anyone knows
>>>nifty commands for determining this? Thanks.
>>
>>Look into audit (SQL). However, you need to audit the tables in question
>>for a while in order for it to be usable for your purposes.
>>
>>hth
>>Rene
>
>
> Silly me. The oracle version is 9.2.0.3
>
> c
Then seriously consider the MONITOR clause for CREATE TABLE and ALTER TABLE.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Thu Oct 07 2004 - 20:11:21 CDT
