Re: ALTER TABLE ADD columns in parallel?
- From: "Rich Jesse" <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 5 Mar 2014 13:06:12 -0600 (CST)
Mark replies:
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts: