Re: Convert table into partitioned table (Fast)
From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 06 Mar 2008 11:39:25 -0800
Message-ID: <1204832364.234757@bubbleator.drizzle.com>
>
> My question was: is there a faster way to convert to a partitioned
> table than "insert into .... select * from ....". I don't think you
> read my post.
Date: Thu, 06 Mar 2008 11:39:25 -0800
Message-ID: <1204832364.234757@bubbleator.drizzle.com>
mccmx_at_hotmail.com wrote:
>>> How would you achieve that..? >> INSERT INTO ... SELECT * FROM ....; >> -- >> Daniel A. Morgan
>
> My question was: is there a faster way to convert to a partitioned
> table than "insert into .... select * from ....". I don't think you
> read my post.
I read your post ... my response was the answer.
If you want it fast use the APPEND hint.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Mar 06 2008 - 13:39:25 CST