SQL & PL/SQL

Hi All,

I am using CTAS to create a Table with nologging and parallel degree 8 in 12C.

My select statement has got joins of 7 to 8 tables .

Sample CTAS statement

create table temp1 PARALLEL (DEGREE 8) NOLOGGING as SELECT * from

table1,table2,table3,..

where ....

and exists (select 1 from candidate_table  ct where ct.customer_id = table1.customer_id);

The query is not running in parallel.

Where as on the same server my inserts and select statements are working parallely.

Suggestions Please

Thanks in Advance