Hi Raj I thought, you were listening to my presentation in HOTSOS 2006 ;-)
Dumping the log file will tell you that.
Thanks Riyaj
*easiest* way, trace it and look at the recursive sql. or you could dump the relevant index blocks to disk before and after.
Me, I probably wouldn't care.
On 4/26/06, rjamya <rjamya@xxxxxxxxx> wrote:
Got a query from my developers, they are trying to use the "update xxx set row " syntax to modify a row using a record.
How would I verify that pk index will not get updated if only non indexed columns were changed in the record?
is there an easy way? btw this is on 10104.
TIA Rjamya ---------------------------------------------- Got RAC? -- //www.freelists.org/webpage/oracle-l
-- Niall Litchfield Oracle DBA http://www.orawin.info -- //www.freelists.org/webpage/oracle-l
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.