Database Tuning (MOSC)

MOSC Banner

alter table < table_name> modify( <column_name> not null) does not work in parallel

in Database Tuning (MOSC) 3 commentsAnswered

I have done the following (Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production))

Issue is: it never runs in parallel. Other process do however.

example table sched_step

alter table SCHED_STEP parallel (degree 8);

ALTER TABLE SCHED_STEP

 MODIFY (CREATION_DB_ID NUMBER NOT NULL),

     CTRL_DB_ID NUMBER NOT NULL);

this takes about 40 minutes but never goes parallel.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center