| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Database Reorg Question
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Meng, Dennis
INET: Dennis.Meng_at_alcoa.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jan 16 2003 - 09:44:42 CST
 |
 |