Tablespace not reclaiming space after deletion [message #56844] |
Wed, 30 April 2003 04:32 |
Anu
Messages: 82 Registered: May 2000
|
Member |
|
|
I have a huge table containing 643000 records. This table and another 2 tables are in same tablespace. Now the tablespace is 99% full. I deleted around 200000 records from this table. After deletion also this tablespace shows 99% full. How can I claim the deleted records space in this tablespace
Thanks in advance
Anu
|
|
|
|
Re: Tablespace not reclaiming space after deletion [message #56865 is a reply to message #56846] |
Thu, 01 May 2003 03:06 |
Anu
Messages: 82 Registered: May 2000
|
Member |
|
|
Thanks mahesh for your reply.
I am using oracle 7.3.3. There is no alter table move option inthis version. What about the following steps.
1. Export the table
2. truncate the table
3. import the dump file
will it work?
what about alter tablespace <> colasce option.
waiting for your reply.
Thanks in advance
Regards
Anu
|
|
|
|
|