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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 .
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 .
http://www.articles.freemegazone.com/shrinking-oracle-datafiles.php