RE: Partitioning Question

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Wed, 19 May 2004 21:42:07 -0400
Message-ID: <42BBD772AC30EA428B057864E203C99911592E@MSGBOSCLF2WIN.DMN1.FMR.COM>

To keep splitting the whole table into many partitions would be too much = pain since you have to scan the entire table (or the rest after a split) = for each split.

Waleed

-----Original Message-----
From: Wolfgang Breitling [mailto:breitliw_at_centrexcc.com] Sent: Wednesday, March 24, 2004 6:12 PM
To: oracle-l_at_freelists.org
Subject: RE: Partitioning Question

1. create an empty partitioned table with 1 partition as select * from = ...=20 where 0=3D1;
2. exchange the original table with the empty partition
3. split the single partition as needed
4. drop and rebuild any indexes - the indexes could be included in the = step=20 2, but I think you'll need to look at the indexes in light of the=20 partitioning scheme

At 03:49 PM 3/24/2004, you wrote:
>And before anyone asks ... We are using 8.1.7.4 on a Solaris 9 system.
>-----Original Message-----
>From: Kevin Lange [mailto:klange_at_ppoone.com]
>Sent: Wednesday, March 24, 2004 4:46 PM
>To: 'oracle-l_at_freelists.org'
>Subject: Partitioning Question
>
>Simple question ... hopefully a simple solution.
>
>
>Is there any way to modify a non-partitioned table to make it =
partitioned=20
>without rebuilding it ? (i.e. no create as select or=20
>export/import. Hopefully a simple alter command).
>
>Thanks for any help.
>
>Kevin

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com=20

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed May 19 2004 - 20:39:04 CDT