Partitioning an Existing Table using EXCHANGE PARTITION
Ref: http://www.oracle-base.com/articles/misc/PartitioningAnExistingTableUsingExchangePartition.php This article presents a simple method for partitioning an existing table using the EXCHANGE PARTITION syntax. The contents of the article should not be used as an indication of when and how to partition objects, it simply shows the method of getting from A to B. Remember, in many cases incorrect partitioning is worse than no partitioning! Create a Sample Schema Create a Partitioned Destination Table EXCHANGE PARTITION SPLIT PARTITION Related articles. Partitioned Tables And Indexes in Oracle 8i Partitioning Enhancements In Oracle9i Hash Partitioned Global Indexes in Oracle 10g Partitioning Enhancements in Oracle Database 11g Release 1 Partitioning an Existing Table using DBMS_REDEFINITION Create a Sample Schema First we create a sample schema as our starting point. -- Create and populate a small lookup table. CREATE TABLE lookup ( id NUMBER(10), description VARCHAR2(50) ); ALTER TABLE lo...