| Reduce the Size of DB [message #276151] |
Wed, 24 October 2007 02:43  |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
Dear All,
Oracle Version: 9.2.0.1.0
Operating System: windows Server 2003
I have a DB with size of 349Gb and its rapidly increasing ,Now i want to reduce the size of my DB
First thing i want to look at the tables which are not being used for the last 3-4 months.
is it possible to find such tables?
imp/exp is also a good option to defragment data but its very time consuming task
in my case its not possible
can u please suggest some other options?
thanx a lot
|
|
|
|
| Re: Reduce the Size of DB [message #276158 is a reply to message #276151] |
Wed, 24 October 2007 03:08  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
| Quote: |
i want to look at the tables which are not being used for the last 3-4 months.
is it possible to find such tables?
|
Activate audit
| Quote: |
imp/exp is also a good option to defragment data but its very time consuming task
|
If you don't purge data, this is useless.
Otherwise use "alter ... move or rebuild" that can be done online but are risky.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
