Re: Convert table into partitioned table (Fast)

On Mar 6, 4:57 am, mc..._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.

If the append hint and Steve's suggestion don't do it for you, perhaps you can do the poor man's parallelization: do a bunch of insert to select froms into tables with appropriate where clauses, and exchange each of those for partitions. Not that I've ever tried it.

jg

--
@home.com is bogus.
http://asert.arbornetworks.com/2008/02/internet-routing-insecuritypakistan-nukes-youtube/