Hi Sean I would make a database trigger on servererror that could call a dump of the session and that way get a error stack and a system state dump tahe inclueds the sql that is executing
O'Neill, Sean wrote: >So this application running on an 8.1.7 database, NT4, has a utility >supplied by vendor which when run by one of our apps people is reporting an >ORA-01410 (invalid ROWID). Given our "history" with the vendor in question >I have some doubts about the application =:-0 > >In relation to same I have a few queries: > >[1] Would an Export of the database report problems if above issue existed >in database?. A full export is currently taken each night and completing >without any warnings. > >[2] Is dbverify any good to troubleshoot this type of error?. I currently >run a dbverify on Offline backups of the data files in question and no >errors are being reported. Granted this is on a "copy" of the datafiles but >I ran a test before where I corrupted a datafile, took a copy, and the >dbverify reported problem with copy so I assume my logic is good here?. > >[3] If I run ANALYZE TABLE xxx VALIDATE STRUCTURE CASCADE on offending table >is output reported to screen? >I have not run it yet as the DB itself is "busy" a lot of the time and above >is rcommended for quite time due to prevention of Selects, Inserts, Updates >and Deletes on object. > >[4] What other methods could be used to troubleshoot this problem?. As I >mentioned I have doubts about the vendor supplied application and would like >to prove one way or the other if some data corruption exists or not! > >Any help with above would be much appreciated :) > >------------------------- >Se�n O' Neill >Organon (Ireland) Ltd. >[subscribed: digest mode] >-------------------------------------------------------------------- >This message, including attached files, may contain confidential >information and is intended only for the use by the individual >and/or the entity to which it is addressed. Any unauthorized use, >dissemination of, or copying of the information contained herein is >not allowed and may lead to irreparable harm and damage for which >you may be held liable. If you receive this message in error or if >it is intended for someone else please notify the sender by >returning this e-mail immediately and delete the message. >-------------------------------------------------------------------- > > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 M�l�v http://miracleas.dk /* The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music Donald Knuth */
smime.p7s
Description: application/pkcs7-signature
