Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> DDL without commit
Hi!
Does anyone know if there is a way to avoid a commit when doing DDL for example creating a table:
insert into test (id) values(1);
create table sometable (id number);
insert into test(id) values(2);
The problem is that if the second insert fails, I would like to rollback both of the inserts, but the first one has already been commited after doing the alter table.
Anyone ??
Regards,
Flemming Jans Received on Wed Feb 18 1998 - 00:00:00 CST