Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Rollback for inserts and deletes

Rollback for inserts and deletes

From: Fuzzy <granta_at_nospam.student.canberra.edu.au>
Date: Fri, 01 Sep 2000 05:25:00 GMT
Message-ID: <39af3d4c.18059538@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


:-)
 
Received on Fri Sep 01 2000 - 00:25:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US