Govind, 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 Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:Govind.Arumugam@;alltel.com] > 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: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
