Convert table into partitioned table (Fast)
From: <mccmx_at_hotmail.com>
Date: Tue, 4 Mar 2008 20:54:36 -0800 (PST)
Message-ID: <0aacbe8b-6f9e-4ca6-ba9c-0d27c6c88bc1@i29g2000prf.googlegroups.com>
Date: Tue, 4 Mar 2008 20:54:36 -0800 (PST)
Message-ID: <0aacbe8b-6f9e-4ca6-ba9c-0d27c6c88bc1@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:
- Rename the existing unpartitioned table
- Create new partitioned table
- Insert into partitioned table select * from unpartitoned table
- 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. Received on Tue Mar 04 2008 - 22:54:36 CST