Re: help~~PARALLEL DML Question

From: Ivan Bajon <iba_at_no_spam@post1.tele.dk>
Date: Fri, 14 Jan 2000 15:19:39 +0100
Message-ID: <85nba2$4cb$1@news.inet.tele.dk>

alter session enable parallel dml;
insert /*+PARALLEL(dest_table,10)+*/ into dest_table select /*+PARALLEL(source_table,10)*/ * from source_table;

The above is using Parallel Query - not Parallel Server - but it should be way faster than normal "insert as select".

hth,
Ivan Bajon, ocp

agichen <agiNOagSPAM_at_feib.com.tw.invalid> wrote in message news:15f5621a.544df703_at_usw-ex0102-013.remarq.com...
> Hello,there
> I have a partition table (with 10 partitions) on ver 8.0.5 with
> parallel server option.
> Now I want to insert 5M records from another table,how to write
> hint in my parallel insert to speed up my task ??
>
> ps.we have 2 node(RS/6000 2CPUs per node)
>
> Rgds,
> Agi Chen
>
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Fri Jan 14 2000 - 08:19:39 CST