| Identifying Unused Schema/Tables [message #272251] |
Thu, 04 October 2007 05:47  |
smunir362
Messages: 310
Registered: September 2007
|
Senior Member |
|
|
describe to me if someone know how to check that
which schema OR tables or not used for the last 3 or 4 months...
So that I remove it to free the space back.......
[mod-edit] removed illiterate IM speak.
[Updated on: Thu, 04 October 2007 07:45] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: Identifying Unused Schema/Tables [message #272260 is a reply to message #272253] |
Thu, 04 October 2007 06:07  |
smunir362
Messages: 310
Registered: September 2007
|
Senior Member |
|
|
it may be an option.
But is there no way
or it can be handled by using some sql and PL/sql ...
like we can determine by examining it by listing in the DB Buffer cache i.e what tables are accessed.
We can create the table and then create a trigger on it which will check the access tables from the buffer cache and insert it into the table and if it exists then ignore......
Can it be an option....
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
