On 21 Aug 2003 at 9:21, Greg Stark wrote: > Andreas Pflug <[EMAIL PROTECTED]> writes: > > Shridhar Daithankar wrote: > > > Just wondering, what other databases has transactable DDLs? oracle seems to > > > have autonomous transactions which is arthogonal. > > > > > M$ SQL2000 has (and previous versions had too, I believe) > > In Oracle DDL (including truncate!) was special and wasn't in a transaction. > I always just assumed that was just the way it had to be.
That is the autonomous transaction. Right now I am looking at interbase/firebird documentation. It looks like it has automous DDL transaction as well.. Bye Shridhar -- Collaboration, n.: A literary partnership based on the false assumption that the other fellow can spell. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster