Re: Ignorant rollback question

From: rok <rok_at_MCI2000.com>
Date: Fri, 15 May 1998 05:22:16 GMT
Message-ID: <01bd7fc1$a3a299c0$b90637a6@raghus-computer>

Yes, it will be using rollback segments. As data is being written to data blocks, 'before' image of these blocks will be written to rollback segments.

raghuvir

Van Messner <vmessner_at_netaxis.com> wrote in article <6jd6qv$8ps$1_at_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 Fri May 15 1998 - 00:22:16 CDT