Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 18436 invoked from network); 22 Jul 2007 05:21:48 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 22 Jul 2007 05:21:48 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F03067141BA; Sun, 22 Jul 2007 06:19:35 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24296-01-22; Sun, 22 Jul 2007 06:19:35 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5A22F716B06; Sun, 22 Jul 2007 06:19:35 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 22 Jul 2007 05:37:57 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 315527168B3 for ; Sun, 22 Jul 2007 05:37:57 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30935-02-13 for ; Sun, 22 Jul 2007 05:37:57 -0400 (EDT) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.180]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C13F5716929 for ; Sun, 22 Jul 2007 05:37:56 -0400 (EDT) Received: by py-out-1112.google.com with SMTP id a73so2851114pye for ; Sun, 22 Jul 2007 02:40:07 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Dddk5p/zCashVIJRSwH5rhwx2ZqgydDkNy9Mr2w9awIiuDOD3nXIUEiYP2jD490sm8oOBHtu+i/nttYPwMnXqUms8XNfQPx0zgQQuvCbAkImOQR3rMOFveYgTgxTvpfVbDvt9+y/d4ce0OHWqN+oxzx76jmcD511aN0aWQ0aC20= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=YQhvvAxvRaFOHOf/qvoLFVoCa1MrReU0oC4SPZLUoyPO3hAV5PxluIhyYnbfaRB0fNktb2cxR2Z++qYwYWD1D7uEniNpCl1+IdMQOdC5YD9glLfHS7Zb5xKBNj8HI0Vj87imDcax4P9JelEo2F7VU9l5ZnKzhP9mLdnEl/iw7dE= Received: by 10.65.214.2 with SMTP id r2mr2960619qbq.1185097207003; Sun, 22 Jul 2007 02:40:07 -0700 (PDT) Received: by 10.64.220.13 with HTTP; Sun, 22 Jul 2007 02:40:06 -0700 (PDT) Message-ID: Date: Sun, 22 Jul 2007 10:40:06 +0100 From: "David Sharples" To: vikramsingh120@gmail.com Subject: Re: Collapse partitions in 9i - What all options do i have? Cc: freelists , oracle-l-request@freelists.org, ora-apps-dba@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_99293_18859110.1185097206963" References: X-archive-position: 51154 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: davidsharples@gmail.com Precedence: normal Reply-to: davidsharples@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_99293_18859110.1185097206963 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline create table xxx as select * from yyy; drop yyy, rename xxx to yyy and rebuild your indexes - with those tiny tables it wont take any time at all On 22/07/07, vikram singh wrote: > > > What are the various ways i have to collapse partitions in a DB? > ------=_Part_99293_18859110.1185097206963 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline create table xxx as select * from yyy; drop yyy, rename xxx to yyy and rebuild your indexes - with those tiny tables it wont take any time at all

On 22/07/07, vikram singh <vikramsingh120@gmail.com> wrote:
 
What are the various ways i have to collapse partitions in a DB?

------=_Part_99293_18859110.1185097206963-- -- http://www.freelists.org/webpage/oracle-l