Re: Rollback for inserts and deletes

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 1 Sep 2000 07:32:39 +0200
Message-ID: <967790106.26132.2.pluto.d4ee154e@news.demon.nl>

"Fuzzy" <granta_at_nospam.student.canberra.edu.au> wrote in message news:39af3d4c.18059538_at_newshost.interact.net.au...
> Hi all,
>
> Trying to do some rollback calculations. From the Oracle manuals, an
> insert places the rowid in rollback, where a delete places the whole
> row.
>
> My question is, does a delete also place in rollback any of the
> relevant structure of the index(es) for a deleted row, or does it
> dynamically recreate an index if a delete is rolled back?
>
> Ciao
> Fuzzy
> :-)
>

Think a sec about it. Wouldn't you think your last option is impossible if your table contains a significant number of rows? The only thing that might happen at delete is reclaiming the unused space, so rearranging *part* of the index. Thus, any changes necessary are placed in rollback.

Hth,

Sybrand Bakker, Oracle DBA Received on Fri Sep 01 2000 - 00:32:39 CDT