Re: ALTER TABLE ADD columns in parallel?

  • From: "Rich Jesse" <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 5 Mar 2014 11:04:37 -0600 (CST)

Mark replies:

> 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

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2014