From oracle-l-bounce@freelists.org Wed Dec 29 08:17:53 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iBTEHrD15933 for ; Wed, 29 Dec 2004 08:17:53 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iBTEHon15919 for ; Wed, 29 Dec 2004 08:17:50 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 239E172CA7F; Wed, 29 Dec 2004 09:24:21 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20422-60; Wed, 29 Dec 2004 09:24:21 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 56E7672CB50; Wed, 29 Dec 2004 09:24:08 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=N3ckZsPgsIFqXVuxi3OOEmffjzHshT2WPJ/I/4JMZc89GSmM8qwIe0j0n5wo1lmZ0wMOWU5m59krtZtnLQPDVf9KAitFGStcHOWlXXH7AqjGiq912ykgVXkTSDNwHqeqvTxHk0V6bPw63SEuZ27Ok7TdZ4qfMM9uOYha2JXUcf4= Message-ID: Date: Wed, 29 Dec 2004 08:22:23 -0600 From: aj wells To: "Mercadante, Thomas F" Subject: Re: B-Tree to Partitioned index Cc: oracle-l@freelists.org In-Reply-To: Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: X-archive-position: 14230 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: awellsdba@gmail.com Precedence: normal Reply-To: awellsdba@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Come to think of it... now what we are on the san with these indexes... I think there may actaully be enough room to build and then rename the index... Funny how sometimes you can manage to see exactly one side and as a result one solution to the problem... =) thanks On Wed, 29 Dec 2004 09:12:09 -0500, Mercadante, Thomas F wrote: > April, > > One suggestion is to just create the new partitioned index with a different > name. When it is complete, drop the old one and rename the new one if you > want it named a certain way. > > Look at the ALTER INDEX RENAME command available in Oracle 9i. If naming it > is not the issue, then just build the new one and drop the old one. > > Hope this helps! > > Tom > > -----Original Message----- > From: aj wells [mailto:awellsdba@gmail.com] > Sent: Wednesday, December 29, 2004 9:04 AM > To: oracle-l@freelists.org > Subject: B-Tree to Partitioned index > > Is there anyway to move from a "normal" b-tree index to a locally > partitioned index online without having to to a rebuild? > > We have fairly large databases (15 TB for the one that we are > concerned with now) and we need to get one of the highest hitting > indexes rebuilt into a partitioned index, but we have no way to do > that elegantly when we are dumping nearly 50 GB an hour into the > database 24 hours a day. > > Suggestions? Docs are not OVERLY helpful here... > > Thanks > aj > -- > http://www.freelists.org/webpage/oracle-l > -- http://www.freelists.org/webpage/oracle-l