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

Report message to a moderator

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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ALTER TABLE SHRINK/COMPACT or export/import

Regards
Michel

Report message to a moderator

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.

Report message to a moderator

Previous Topic: having problem when i take rman backup
Next Topic: IMP Error IMP-00058: ORACLE error 1034 encountered
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 17:32:29 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.