Hi,
This is kind of a dumb question but please bear with me... In rollback
segment, any change I make to the transaction is kept in till I commit.
My question is suppose I make some column value updates and those
columns are index columns for that table. And didnot commit and went
ahead, used that value I set for that column to make a search on the
table. How will Oracle use the index ? Since I have not committed any
changes, will it go and look for the data using the index in rollback?
Thanks in adv...
Dogan
Received on Thu Aug 05 1999 - 16:22:24 CDT
