-On [20030909 00:42], Tom Lane ([EMAIL PROTECTED]) 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... ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
