Re: Ignorant rollback question

From: Van Messner <vmessner_at_netaxis.com>
Date: Wed, 13 May 1998 18:28:25 -0400
Message-ID: <6jd6qv$8ps$1@news7.ispnews.com>

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.

Van

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

>> In a database with an existing table T and index I, if you
>> drop I
>> drop T
>> create T as
>> select x from y
>> create I
>> And if there are no explicit commits, Then what, if any, changes are made
to
>> rollback segments?
Received on Wed May 13 1998 - 17:28:25 CDT