Home » RDBMS Server » Server Administration » Recovering tablespace freespace after deleting records
Recovering tablespace freespace after deleting records [message #57751] Thu, 03 July 2003 09:08 Go to next message
shareef
Messages: 72
Registered: November 2002
Member
We have deleted subtantial amount of records from a huge table. After the deletion too, the free space shown in dba_free_space is still the same. How can we make sure that database has recovered the space of deleted records?

Our aim by deleting records from database is to avoid increasing tablsespace size.

Earliest respnse is highly appreciated
Re: Recovering tablespace freespace after deleting records [message #57753 is a reply to message #57751] Thu, 03 July 2003 11:18 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
deleting the records will not free up the space.
you should truncte the table.
if trunctation is not possible, directly try one of these methods

create table new_table as select * from old_table;
truncate table old_table;
insert into old_table (select * from new_table);

----------------------------------------------------------------------

or

----------------------------------------------------------------------

alter table table_name move tablespace < T0_same_tablespace_as_it_was_before >

Previous Topic: Creating DB Link
Next Topic: why oracle uses spfile??
Goto Forum:
  


Current Time: Fri Sep 20 13:43:25 CDT 2024