On Wednesday 15 August 2007 1:58:07 am Harpreet Dhaliwal wrote: > So you mean to say something like this as far as oracle is concerned: > > BEGIN > DDL 1 (commits right after its execution) > DDL 2 (commits right after its execution) > END > > That means there's no concept of putting DDL statements in a transaction in > oracle basically, right?
Even worse: In certain transaction isolation levels (READ COMMITTED and SERIALIZABLE IIRC) it yells at you and doesn't perform the DDL command. Which makes it virtually impossible to do dynamic DDL in any serious J2EE application. <rant> God, how I hate Oracle. </rant> > > Thanks, > ~Harpreet jan > > On 8/15/07, Scott Marlowe <[EMAIL PROTECTED]> wrote: > > On 8/14/07, Harpreet Dhaliwal <[EMAIL PROTECTED]> wrote: > > > So you mean to say DDL statements can't be put in one single > > > transaction > > > > in > > > > > Oracle ? > > > > You can put them in, but then they will cause the previous DMK to be > > silently committed ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
