Skip to Main Content
Forums

SQL & PL/SQL

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!

DDL-Tuning - How to speed up a DDL - Creating a NOT NULL Constraint

HansMueller69Aug 30 2018 — edited Aug 30 2018

Hi Experts

I have a very big table.

And I have filled one column and I need to set this column to NOT NULL.

The statement is:

ALTER TABLE OMG.OMG_BUSINESS_PLAN MODIFY (X_TRANSAKTION NOT NULL)
/

But it does not run parallel.

I executed this one before the above statement but it does NOT HELP:

ALTER SESSION FORCE PARALLEL DDL PARALLEL 16
/

As I see, the statement ALTER TABLE is running serial and it takes much time.

Could you tell me how I could run it parallel?

Thanks in advance, Hans
This post has been answered by AndrewSayer on Aug 30 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 27 2018
Added on Aug 30 2018
5 comments
1,898 views