Home » RDBMS Server » Enterprise Manager » how to reuse the space been recovered from table's row deletion
how to reuse the space been recovered from table's row deletion [message #298296] Tue, 05 February 2008 10:41 Go to next message
sudhir_sahu
Messages: 10
Registered: September 2007
Junior Member
hi all
I have table1 with 1000000 records.
similarly table2 with 20005687 records.
Now I have deleted few rows from both tables.
Now I want to free the space been used by these tables' empty rows.
For this I use
alter table tablename enable rowmovement;
alter table tablename shrink space;
In this way the space is recovered and I can use this space for some other segments lying in the same tablespace and of the same database.Since tablespace is still not defragmented so how can I resize the tablespace and reuse this space for some other segments in different database.

Thanks in advance
Re: how to reuse the space been recovered from table's row deletion [message #298318 is a reply to message #298296] Tue, 05 February 2008 12:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Very too much work for very small advantage if not nothing if you "deleted few rows from both tables".

Regards
Michel
Re: how to reuse the space been recovered from table's row deletion [message #298370 is a reply to message #298296] Tue, 05 February 2008 23:31 Go to previous messageGo to next message
sudhir_sahu
Messages: 10
Registered: September 2007
Junior Member
Actually there are more than 1000 such tables and I have deleted round about 100000 rows from each table.
and all the tables are releasing more than 15 GB then.
Re: how to reuse the space been recovered from table's row deletion [message #298374 is a reply to message #298296] Tue, 05 February 2008 23:49 Go to previous message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
At $1/GB for disk space, how long did it take for you to recover his "valuable" disk space and what is your hourly rate?
Previous Topic: Oracle Expert username/password
Next Topic: On system startup Oracle Instance is not getting started
Goto Forum:
  


Current Time: Sat Dec 03 20:12:11 CST 2016

Total time taken to generate the page: 0.08649 seconds