Tablespace RESIZE

[burgaParticipante]

E aí Peterson,

Vê se esse tópico te ajuda.

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7149039425561

Tom,
We have recently upgraded to Oracle 10g and as part of the upgrade process we converted also large
table (30Gb) into partitioned one by doing insert select… old table after this was dropped. As
result, tablespace which contained these tables become blown up to 60Gb and I believe has structure
like ffffffuuuuuu as older table was removed. Is there any way of reducing datafile back to 30Gb? I
understand that alter table move can do the trick, but will table be accessible during this
operation (there are some long running processes accessing this table almost constantly)? Is there
other ways to do this?
Thanks.

Followup September 1, 2004 – 8pm Central time zone:

with 10g you have an easier online “reorg” process with dbms_redefinition — you would have to move
this to another tablespace, and then just drop this one.

so, either online reorg or offline reorge but in anycase — if you have the ffffffuuuuuu in a
datafile — it will take a reorg to “reclaim”

Hint: when rebuilding in the future, rebuild into a new tablespace. In 10g you can even rename a
tablespace to put it back after you drop the old if you like.

Abraços,