Finding some idle Tables

Dear All,

I want to know some idle tables in some of my production Schema
For Example
i want to search those tables on which no activity (select,insert,update,delete) for the last 2-months.

Auditing is available for this task but i don't have auditing enabled ,is there any other option except auditing ?

Please suggest!

no

Might he not be able to use LogMiner in some fashion? (assuming he has all the logs from the past two months and is at 9i or higher)

That would cover insert / update / deletes, but not selects. Other than auditing, there is no record of who selected what when from where.

Quote:

---

Originally Posted by jhmartin

That would cover insert / update / deletes, but not selects. Other than auditing, there is no record of who selected what when from where.

---

Dang - knew I was missing something :D

Quote:

---

Originally Posted by chrisrlong

Might he not be able to use LogMiner in some fashion? (assuming he has all the logs from the past two months and is at 9i or higher)

---

Although i have very limited knowledge abt Logminer ,can u please tell me how to user Logminer to accomplish my requirements?

I'll thankful to u

it doesnt accomplish all your requirements