Home » RDBMS Server » Enterprise Manager » To recover the space been used by deleted rows of a table
To recover the space been used by deleted rows of a table [message #292518] Wed, 09 January 2008 02:03 Go to next message
sudhir_sahu
Messages: 10
Registered: September 2007
Junior Member
I have tablespace with autoextend on.
I was having 200000 rows in the table say emp.
Now I have deleted 100000 rows from table emp.
I want to recover the space been used by deleted rows.
Can anybody tell me how can I recover the space?
Thanks in advance.

[Edit MC: change title (sorry Mohammad did not see your post before changing the title)]

[Updated on: Wed, 09 January 2008 02:13] by Moderator

Report message to a moderator

Re: to [message #292520 is a reply to message #292518] Wed, 09 January 2008 02:11 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Sudhir,
1. Create proper topic Title.
2. Search on forms this question recently asked.
Re: to [message #292526 is a reply to message #292520] Wed, 09 January 2008 02:21 Go to previous messageGo to next message
sudhir_sahu
Messages: 10
Registered: September 2007
Junior Member
I am not able to find the problem in the forms.
Please help me out.
Re: to [message #292529 is a reply to message #292526] Wed, 09 January 2008 02:40 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

http://www.orafaq.com/forum/m/234328/93410/?srch=released+table+space#msg_234328
Re: to [message #292544 is a reply to message #292529] Wed, 09 January 2008 03:19 Go to previous messageGo to next message
sudhir_sahu
Messages: 10
Registered: September 2007
Junior Member
Dear Mr. Mohammad Taj

I am not able to understand the solution for that problem.

Actually the problem is this:
there is a database say A.
I have deleted few thosand rows from each table of this database.
Now I want to defragment my database so that it will take a lesser space. Please tell me how it can be done?

Thanks in advance.
Re: to [message #292550 is a reply to message #292526] Wed, 09 January 2008 03:29 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Table size doen not reduce topic.

Regards
Michel
Previous Topic: Instance Not starting
Next Topic: Enterprise Manager Grid Control
Goto Forum:
  


Current Time: Thu Mar 28 06:33:37 CDT 2024