Database Administration (MOSC)

MOSC Banner

parallel DDL modify column to null

edited Feb 6, 2018 1:40PM in Database Administration (MOSC) 5 commentsAnswered ✓

Hello Gurus,

11203

rhel 6

I'm trying to modify an existing column to nullable and its taking a lot of time. Table contains lot of interval/reference partitons and have LOBS,my question is does making a not null column to null should be quick isn't it?  does it need to update the table?

I tried doing following but it still runs in serial mode. How do i make it run in parallel or speed up the operation?

Alter table <table_name> parallel 8;

Alter session force parallel ddl;

Alter table <table_name> modify null; --Your DDL statement.

Alter table <table_name> noparallel

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

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