| address of row [message #62572] |
Thu, 29 July 2004 22:18  |
jayesh
Messages: 6
Registered: December 2003
|
Junior Member |
|
|
hi experts
how can we found where exactly the tables rows residing.
i am using oracle 8i.is there any way to find if i am selecting
a row eg 1000 th row or a range from 1000 to 1500 rows.
without using rowid.be cause i had some block corruption
got error .so i am not able to find select the rowid.can anyone help
wiht regards
jayesh
|
|
|
|
| Re: address of row [message #62612 is a reply to message #62572] |
Tue, 03 August 2004 00:48  |
Satheesh Babu.S
Messages: 35
Registered: July 2004
|
Member |
|
|
Hi,
when 1578 error is thrown it will tell you the file id and block id. Using this you can find out the rowid of those record using dbms_utility. Using this find the rowid belongs to that corrupted block. While selecting you can excludes these rows.
Thanks and Regards,
Satheesh Babu.S
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
