RE: Partitioning Question

From: Kevin Lange <klange_at_ppoone.com>
Date: Wed, 24 Mar 2004 17:26:36 -0600
Message-ID: <ED1256BD4F253C44B1627B2D365A334F019DC298@ppoone1.ppoone.com>

I see.

Thanks for the info. I will bone up on the 'Exchange' option on the alter command.

I appreciate the help.

Kevin

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

1. create an empty partitioned table with 1 partition as select * from ... where 0=1;
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 2, but I think you'll need to look at the indexes in light of the 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
>without rebuilding it ? (i.e. no create as select or
>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

---

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 Mar 24 2004 - 17:24:21 CST