Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

parallel in a create table statement

Guess2Oct 26 2009 — edited Oct 29 2009
If 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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2009
Added on Oct 26 2009
7 comments
937 views