Forum OpenACS Q&A: reclaiming space from dropped tables in Oracle ?

1: reclaiming space from dropped tables in Oracle ?

Posted by Allan Regenbaum on 04/05/02 09:44 PM

Running Oracle with ACS

im in a situation where I have an oracle tablespace on a volume which
has minimal diskspace

Im required to move 5 large tables from this tablespace to a new
tablespace on a different volume.

I
exp ts1/pwd tables=table1 file=table1.dmp
imp ts2/pwd tables=table1 file=table1.dmp

on ts1 I drop or truncate table1 and then
alter database table1 '/ora8/m02/oradata/ora8/ts1.dbf' resize 1600M;

its not showing reduced space usage for ts1, in fact when I imp to
ts2 df -k shows greater disk usage on ts1's volume

how can I reclaim this space from the dropped tables on ts1 ?

TIA...

2: Response to reclaiming space from dropped tables in Oracle ? (response to 1)

Posted by Sebastiano Pilla on 04/08/02 11:34 AM

Have a look at How can I reclaim unusable fragments of space in a tablespace ? and bookmark the site (Oracle Users' Cooperative FAQ) for answers to almost all of your future Oracle questions.