Re: Convert table into partitioned table (Fast)

<mccmx_at_hotmail.com> wrote in message
news:0aacbe8b-6f9e-4ca6-ba9c-0d27c6c88bc1_at_i29g2000prf.googlegroups.com...
> 10g Release 2
>
> Whats the fastest way to convert a very large table into a partitioned
> table. The operation doesn't have to be done online but it needs to
> completed as quick as possible.....
>
> Current plan is to:
>
> 1. Rename the existing unpartitioned table
> 2. Create new partitioned table
> 3. Insert into partitioned table select * from unpartitoned table
> 4. Create indexes, constraints, etc
>
> Is there a faster way to achieve this.
>
> I've tried using direct loading using the /*+ APPEND */ hint but this
> doesnt increase the throughput significantly. Delaying the index
> creation until after the load however does massively improve load
> times.
>
> Any other ideas..?
>
> Thanks in advance.
>

Have you looked at creating a partitioned table and then doing an exchange? It should take very little time.
Jim Received on Wed Mar 05 2008 - 00:55:59 CST