Oracle Database Discussions

Any clue as to why combining "alter session disable parallel query" with "alter session enable parallel dml" does not work? Is it that parallel DML needs parallel query to be on?

Reason I ask is that I would to:

insert into tableA
select * from table B;

I want that to be parallelized. For that I will

alter tableA parallel;
alter session enable parallel dml;

Yet I don't want select statements to go parallel on TableA, thus thought of: alter session disable parallel query

But then again alter session disable parallel query kinda disables alter session enable parallel dml.

BTW, I can't add hints as we don't have control over SQL statements.
Have read DOP will use precedence rule. i.e. if insert is done in parallel select will also go parallel. Maybe disabling parallel query indirectly disables parallel DML unless forced.

Does that make sense?

TIA