Home » RDBMS Server » Server Administration » Reduce the Size of DB
Reduce the Size of DB [message #276151] Wed, 24 October 2007 02:43 Go to next message
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 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: error while quering
Next Topic: Detection of oracle installation
Goto Forum:
  


Current Time: Mon Dec 05 23:55:00 CST 2016

Total time taken to generate the page: 0.12977 seconds