Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Ora-01410, Invalid rowid
fanfan
post Jan 31 2008, 05:18 PM
Post #1


Newbie
*

Group: Members
Posts: 2
Joined: 31-January 08
Member No.: 16,753



I have a table which is partitionning ,whenever I pass a query it said
invalid rowid(ora-01410)but it don't contains index.I make analyse over the tabler ,there are
no rows in the table invalid_rows.What I can do to repair this because we cannot
get data from the table.I create another table and use exchange partition to load the datas in the new table but it still say invalid rowid?
Can I use Rman to resolve it
What technic to use to check the invalid rowid,I have a lot of rows in
the table?.I have each block id by using the dba_extents ,how can I
find the rowid with the bloc id in order to find all invalid rows and drop them.

Thanks in advance
Go to the top of the page
 
+Quote Post
crottykt
post Feb 1 2008, 06:11 AM
Post #2


Advanced Member
***

Group: Members
Posts: 180
Joined: 2-August 05
From: Raleigh, NC
Member No.: 2,640



Well the format of the rowid is: block id, row in block, file id

Since you know the block id, you may be able to use a statement such as

delete from <table> where rowid like '<block id>%'

You can find more info here:

http://www.dba-oracle.com/t_ora_01410_invalid_rowid.htm


--------------------
Kent Crotty
Go to the top of the page
 
+Quote Post
fanfan
post Feb 1 2008, 11:58 AM
Post #3


Newbie
*

Group: Members
Posts: 2
Joined: 31-January 08
Member No.: 16,753



I'm not doing insert or update on the table ,I only want to do a select on the table.My problem i don't know which block id was wrong.When I use the dba_extents view ,i find the block id for each datafile .My question ,what technic can help me found the invalid rows in the table ?My table has a lot of datafile and one tablespace and I use oracle 9i.

Thanks in advance for a solution



QUOTE (crottykt @ Feb 1 2008, 06:12 AM) *
Well the format of the rowid is: block id, row in block, file id

Since you know the block id, you may be able to use a statement such as

delete from <table> where rowid like '<block id>%'

You can find more info here:

http://www.dba-oracle.com/t_ora_01410_invalid_rowid.htm
Go to the top of the page
 
+Quote Post
Asad
post Feb 1 2008, 01:40 PM
Post #4


Advanced Member
***

Group: Members
Posts: 392
Joined: 30-November 05
From: AZ
Member No.: 3,343



QUOTE (fanfan @ Jan 31 2008, 10:19 PM) *
I have a table which is partitionning ,whenever I pass a query it said
invalid rowid(ora-01410)but it don't contains index.I make analyse over the tabler ,there are
no rows in the table invalid_rows.What I can do to repair this because we cannot
get data from the table.I create another table and use exchange partition to load the datas in the new table but it still say invalid rowid?
Can I use Rman to resolve it
What technic to use to check the invalid rowid,I have a lot of rows in
the table?.I have each block id by using the dba_extents ,how can I
find the rowid with the bloc id in order to find all invalid rows and drop them.

Thanks in advance


does this table has any foreign key?

please put up the query you're using with execution plan, and cut paste the error.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 26th November 2014 - 11:05 AM