Oracle-L: Re: Troubleshooting ORA-01410

From: <Chaim.Katz_at_Completions.Bombardier.com>
Date: Wed, 12 Jun 2002 11:13:32 -0800
Message-ID: <F001.0047C44F.20020612111332@fatcity.com>

Sean,
[4] If the problem is in the application, maybe you could trace it for a
bit, and see what the SQL looks like.
A select * from emp where rowid = '1' will give the ORA-01410 error. A select using an Oracle7 type rowid against an Oracle8i database will also give the error.

Hth,
Chai

"O'Neill, Sean" <Sean.ONeill_at_organon.ie>@fatcity.com on 06/12/2002 11:53:27 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

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.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: O'Neill, Sean
  INET: Sean.ONeill_at_organon.ie

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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Chaim.Katz_at_Completions.Bombardier.com

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).

Received on Wed Jun 12 2002 - 14:13:32 CDT