Home » RDBMS Server » Backup & Recovery » how to free tablespace after delete data from database (oracle 10g R2)
how to free tablespace after delete data from database [message #423713] Sun, 27 September 2009 03:28 Go to next message
sbldba
Messages: 4
Registered: September 2009
Location: Dhaka
Junior Member
hi
i have a database which has 100 million data. i have deleted 10 million data from the database but i didn't free space for that deleted data. no space is freed from tablespace. can anyone tell me how can i make the tablespace free for deleted data.

thanks

junior DBA
Re: how to free tablespace after delete data from database [message #423719 is a reply to message #423713] Sun, 27 September 2009 04:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALTER TABLE SHRINK/COMPACT or export/import

Regards
Michel
Re: how to free tablespace after delete data from database [message #423772 is a reply to message #423719] Mon, 28 September 2009 00:10 Go to previous message
sbldba
Messages: 4
Registered: September 2009
Location: Dhaka
Junior Member
Dear Michel,

Thank you very much for your reply.. and solution.
Previous Topic: having problem when i take rman backup
Next Topic: IMP Error IMP-00058: ORACLE error 1034 encountered
Goto Forum:
  


Current Time: Tue Dec 06 00:21:18 CST 2016

Total time taken to generate the page: 0.11369 seconds