On 8/14/07, Harpreet Dhaliwal <harpreet.dhaliwal01@xxxxxxxxx> 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 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match