Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Convert DM TSP to LM TSP w/ lots of data

RE: Convert DM TSP to LM TSP w/ lots of data

From: Jesse, Rich <>
Date: Thu, 31 Oct 2002 09:13:47 -0800
Message-ID: <>


We have just implemented Quest's LiveReorg, which I plan to use in our conversion to LMT. Does it completely eliminate downtime? No, but in our shop, I'll be able to do the conversion in "quiet" hours on weekends without the need to keep users completely off of the system (i.e. I don't need to schedule downtime). How applicable this is to other shops depends on how many users, how active they are and when, the nature of the system/data, etc. It just happens to fit very well for us at this point.

My $.02,


Rich Jesse                           System/Database Administrator              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: []
> Sent: Tuesday, October 29, 2002 11:49 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Convert DM TSP to LM TSP w/ lots of data
> This is what we have in mind.
> For the partitioned tables that are going to have the
> 'rotation' logic,
> we will convert them to LMT when they become empty. We drop the
> 'oldest' partition and create a new one for next month. This will be
> carried out every month. Partition for November data is empty
> now and is
> being converted to use LMT as of this week; Next month we will do the
> same for December partition; This way, we would convert all our 5
> CALLDETAIL tablespaces to use LMT in 5 months time.
> Now, for other tablespaces that contain data and indexes, we need to
> decide whether we should create corresponding LMT tablespaces and move
> the existing objects to it or change them using the procedure that
> Oracle recommends; Some of these tablespaces are sized
> anywhere from 5Gb
> to 60Gb and we do not have much of freespace as buffer. Our database
> size is about 1.2 tera bytes. Also for this we might have to
> ask for a
> bigger maintenance window which will be hard to get. So we are toying
> up with the idea of converting them from DMT to LMT using 'in place'
> mechanism and rebuild the tables/indexes eventually as time permits.
> Obviously, we are not trying cause any outage knowingly. Hence these
> questions to the forum.
> Thanks,
> Govind

Please see the official ORACLE-L FAQ:
Author: Jesse, Rich

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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 Oct 31 2002 - 11:13:47 CST

Original text of this message