Re: DDL without commit

Flemming Jans (jans_at_gmx.net) wrote:
: Does anyone know if there is a way to avoid a commit
: when doing DDL for example creating a table:

Not easily, no.

You may be able to fake it using something like DBMS_PIPE:

Session 1 inserts a record.
Session 1 writes a create table request to a pipe. Session 2, listening on the pipe, issues a create table statement.
Session 1 inserts another record.
Session 1 performs a rollback -- one would suspect that this would roll back both inserts, since the create table was performed by a different session (in, therefore, a different transaction). But I haven't tried this myself so I don't know if it would work.

Also, of course, the table would remain after the rollback.

-- 
-bn
random_at_interaccess.com	(PGP 2.6.2 public key available on request)
"There is no .signature -- only ZUUL!"