| To recover the space been used by deleted rows of a table [message #292518] |
Wed, 09 January 2008 02:03  |
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 #292544 is a reply to message #292529] |
Wed, 09 January 2008 03:19  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
