parallel in a create table statement
Guess2Oct 26 2009 — edited Oct 29 2009If I do
create table <table_name>
parallel 6
as
select /*+ parallel(table_name,2) */
I know that the paralle in the select statement means parallel on the select. What does the paralell on the table create table mean? does it only mean that the parallel is when people read the table? Or is it parallel on the write? If its parallel on the write, does it do anything if the table is not partitioned?