Re: Convert table into partitioned table (Fast)
Date: Wed, 05 Mar 2008 06:55:59 GMT
<mccmx_at_hotmail.com> wrote in message
> 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
> 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