Re: converting to partititions

If all the data in the table is to go into one partition of the new partitioned table, then an EXCHANGE PARTITION is the easy trick.

To break a single table into sections I suggest:

    create t1 as select from big_table where {condition 1}     exchange partition t1 into partitioned_table;     drop table t1;

    create t2 as select from big_table where {condition 2}     exchange partition t1 into partitioned_table;     drop table t2;

    etc.

Create the empty partitioned table, with its indices, first and analyze it

Use the Unrecoverable option on create table Create the indices (unrecoverably) on each extracted table in turn analyze the extracted table
use the options:

    including indexes without validation (check syntax) on the exchange.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

pauldb wrote in message <929954312.3235_at_www.remarq.com>...
>
>What is the easiest way to convert a non-partitioned
>table into a partitioned table- to export the table and
>re-import the data into a new partitioned table or
>to do an exchange partition.
>
>I would appreciate any help on this matter.
>
>Thanks very much,
>Paul
>
>
>
>**** Posted from RemarQ - http://www.remarq.com - Discussions Start Here
(tm) **** Received on Mon Jun 21 1999 - 04:28:41 CDT