We are running Oracle 8i on Sun Solaris 2.8.

My question is:

Is the insert phase of
insert into partition_table1
select ... from partition_table2 where ...
parallelized in sync with select

I know the answers is yes if it is

create table ... as select (pCATS)

Thank you!