Hi all
-
We
have a data warehouse database that is very fragmented on the tablespace level
and a lot of space can not be reused because the space 'bubbles' are too small
to fit the tables. We would like to reorg and reclaim the space ( more than 13G
) by using the 'SAFE' method - moving tables and indexes to different
tablespaces according to their size and specify storage parameters only on the
tablespace level. Also we would like to kill two birds with one stone by
converting to locally managed tablespace. So here is the plan of attack
-
Every
weekend we will get some downtime and create a new LMT tablespace and move some
tables to this new tablespace. Eventually all tables will reside in LMT ( except
system ts of course ).
I have
some questions about this though :
1.
Does this sound like a good plan?
2. If
we use 'alter table move...' command to move the table from a conventional ts to
LMT ts, are there any issues?
3.
After moving the table from one ts to another, how do we reclaim the space
left by the table? The only way is to shrink the data files,
correct?
TIA
Dennis