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? Yes. //Magnus ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend