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?
Thanks,
~Harpreet
On 8/15/07, Scott Marlowe <scott.marlowe@gmail.com> wrote: On 8/14/07, Harpreet Dhaliwal <harpreet.dhaliwal01@gmail.com> 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