Re: ALTER TABLE ADD columns in parallel?

> Try this instead:
> Alter table erptbl add (newcol1 nchar(1) default ΠΠnot null);
>
> I think you¹ll find that if you add the ŒNOT NULL¹, it becomes DDL only
> operation, and completes w/ sub second response.

Perhaps, but a NOT NULL constraint and DEFAULT value are very different. The NOT NULL will error out when violated whereas the DEFAULT value will just fill in the gap.

And I'm not able to modify the SQL...

Thanks for the feedback!

Rich

--
http://www.freelists.org/webpage/oracle-l