Re: Ignorant rollback question

From: Brett Neumeier <random_at_enteract.com>
Date: 20 May 1998 18:18:20 GMT
Message-ID: <6jv6pc$o8q$3@eve.enteract.com>

Van Messner <vmessner_at_netaxis.com> wrote:
> I know about the implicit commits but I wanted to know for sure that the
> "select x from y" part of the create wouldn't affect rollback segments.

In fact, DDL commands perform implicit commits both /before/ and /after/ they are executed. (This means that if your "create table as select" fails because you run out of space in the tablespace, the table creation will be rolled back but any changes you had made prior to the DDL command will have been committed.)

The query itself will not generate rollback, because queries don't. (Unless they are "for update")

> Vince Carbone wrote in message <355A1933.686353F9_at_sequent.com>...
> >No rollback is generated for DDL statements.

This is not actually correct, by the way. Received on Wed May 20 1998 - 13:18:20 CDT