Re: Puring Ancient Scheme Objects

From: Mark Bole <makbo_at_pacbell.net>
Date: Fri, 06 Aug 2004 02:16:28 GMT
Message-ID: <0SBQc.868$AJ2.189@newssvr29.news.prodigy.com>

Joel Garry wrote:

> melliott42_at_yahoo.com (Michael) wrote in message news:<91721cf.0408010954.50fb7961_at_posting.google.com>...
> 

>>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.
>>
>>Thanks,
>>
>>Michael

> 
> 
> Do you have any old backups or exports?  Do you have a lot of disk
> space?
> 

[..]

Ask the application developers to share their current code (development database).

They should be able to explicitly list every database object that is referenced in their code. Otherwise, trouble ahead.

--Mark Bole Received on Thu Aug 05 2004 - 21:16:28 CDT