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@xxxxxxxxxx] Sent: Wednesday, March 24, 2004 4:46 PM To: 'oracle-l@xxxxxxxxxxxxx' 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
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
