Re: constraint modification on todo list

-On [20030909 00:42], Tom Lane (tgl@sss.pgh.pa.us) wrote:
>IIRC, Oracle does not have rollback-able DDL.  That might imply that the
>reason they have MODIFY CONSTRAINT is that in Oracle you can't use the
>above way to eliminate the window.  Can you put ALTERs inside
>transactions at all in Oracle?

As one of the Oracle gurus at work told me:

DDL does an implicit commit, so no rollback possible.
It also shouldn't be necessary, because you cannot change a table which
is in use.
It attempts to do a table lock and it fails.

-- 
Jeroen Ruigrok van der Werven <asmodai(at)wxs.nl> / asmodai
PGP fingerprint: 2D92 980E 45FE 2C28 9DB7  9D88 97E6 839B 2EAC 625B
http://www.tendra.org/   | http://www.in-nomine.org/~asmodai/diary/
We should take care not to make the intellect our god; it has, of
course, powerful muscles, but no personality...