Link to home
Start Free TrialLog in
Avatar of oraclescsa
oraclescsa

asked on

Reduce Oracle Database size

Dear Experts ,

I have oracle 9i database and 10g database in the company which is used for testing purpose. The Database Size is 42 GB and the company decided to remove 2 year old data and  take the export and store it on the DVD and use this server for different purpose.
I have deleted almost 90 % of the data from almost 100 tables but the size of the database is not reduced. The Database size is still the same.
I know that oracle 9i does not reclaim the free space. As far as i know for oracle 10g we can use shrink space or shrink space compact

So i need to reduce the size to as less as possible. So what is the best way to do that ?

Please let me know to reduce the size of the database for both 9i and 10g database ?

Thanks

Avatar of tigin44
tigin44
Flag of Türkiye image

you should shrink the database files this link may halp you.

http://www.articles.freemegazone.com/shrinking-oracle-datafiles.php
ASKER CERTIFIED SOLUTION
Avatar of Aaron Shilo
Aaron Shilo
Flag of Israel image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of oraclescsa
oraclescsa

ASKER

Dear Ashilo,

In Oracle 9i i have the same as suggested and it is successful.

In oracle 10g do i need to rebuild the index after running the shrink space compact command.
Is there any impact if this command is used .