tag:blogger.com,1999:blog-8884584404576003487.post8251285150825513580..comments2024-02-29T09:43:12.251-05:00Comments on ORACLENERD: ORA-08103: object no longer existsoraclenerdhttp://www.blogger.com/profile/12412013306950057961noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-8884584404576003487.post-73888342247736229112011-03-19T02:33:02.471-04:002011-03-19T02:33:02.471-04:00@gary
those are definitely on the list for next t...@gary<br /><br />those are definitely on the list for next time...hopefully i'll have more time than i do now.<br /><br />muchas gracias.oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-44687754924009688442011-03-19T02:09:41.454-04:002011-03-19T02:09:41.454-04:00Have you considered
DB_BLOCK_CHECKING and DB_BLOC...Have you considered <br />DB_BLOCK_CHECKING and DB_BLOCK_CHECKSUM next time ?<br /><br />http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams039.htm<br /><br />http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams040.htm#CHDDCEIC<br /><br />They might at least indicate if the issue comes from memory corruption (picked up when DBWR writes block to disk from memory) or disk corruption (picked up when DBWR reads block from disk).<br /><br />Some form of RAID would (in theory) help in the latter.<br /><br />But then IANADBA (equivalent of "I am not a lawyer").SydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-70279442562507563062011-03-18T21:07:05.758-04:002011-03-18T21:07:05.758-04:00I'd suspect an unusable or invalid index on a ...I'd suspect an unusable or invalid index on a not null column (or a bitmap index on any column). The count(*) would use the index, but a where rownum query wouldn't.<br /><br />Try dropping any indexes on it. Or a full_scan hint. Or ALTER SESSION SET SKIP_UNUSABLE_INDEXES=TRUESydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-83219103443419808252011-03-18T19:59:43.922-04:002011-03-18T19:59:43.922-04:00Can you create table as SELECT * FROM eligibility ...Can you create table as SELECT * FROM eligibility WHERE rownum < 11;<br /><br />Are there indices on the table?<br /><br />If the ctas doesn't work, how about setting a delimiter, spooling select * to a file, and using sqlloader?<br /><br />If you find you are dying on a particular bogus block, there may be some way to force that to be skipped. (dbms_repair, skipping bad blocks, some other stuff I can't think of because I am trained to run for the train).Joel Garryhttps://www.blogger.com/profile/13325061229393838224noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-28569956462484485272011-03-18T18:59:30.094-04:002011-03-18T18:59:30.094-04:00I'd say depends, but... In this case, if ther...I'd say depends, but... In this case, if there's any question, load again. It may take as long to figure it out only to find you can't recover anyway. Just my quantitatively eased 3 cents.EscVectorhttps://www.blogger.com/profile/14314875171012421919noreply@blogger.com