Re: Troubleshooting ORA-01410

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
*/ 





Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii"
Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact Postmaster_at_fatcity.com for clarification.

--------------ms060702010902070108040005--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Gram
  INET: peter.gram_at_miracleas.dk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



application/x-pkcs7-signature attachment: smime.p7s