Re: ALTER TABLE ADD columns in parallel?

> If you can separate the column add and the default, it will run w/
> DDL-only update, and not require the NOT NULL.
>
> SQL> set timing on
> SQL> alter table testme add(blah2 nchar(1));
>
> Table altered.
>
> Elapsed: 00:00:00.01
> SQL> alter table testme modify(blah2 default ' ');
>
> Table altered.
>
> Elapsed: 00:00:00.01

A line from the movie "O Brother Where Art Thou?" comes to mind: "That don't make no kinda sense."

While I can't use that method, I sure want to test it now!

Thanks!

Rich

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