| how to reuse the space been recovered from table's row deletion [message #298296] |
Tue, 05 February 2008 10:41  |
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
