Re: Oracle transactions and DDL statements.

Jim Kennedy skrev:

> <peter.koch.larsen_at_gmail.com> wrote in message
> > I do not have uncommitted data per se, but when I change the datamodel,
> > this change involves several tables and triggers and might span more
> > than one database (only one of them being from Oracle), There are also
> > non-database subsystems that participate in the distributed
> > transaction. The problem occurs if e.g. the non-database transaction
> > must abort the transaction for one reason or the other.
> > >

[snip]

> You shouldn't be creating objects in the middle of a transaction. Start or
> end the transaction before creating objects.
> Jim

But what if my transaction requires the creation or destruction of ten tables? This is what I wrote above, this is what the software does and this what caused it to fail: you can't abort it after having created the first five tables as those table alerady have been created.

/Peter Received on Wed May 10 2006 - 04:19:10 CDT