Home » RDBMS Server » Server Administration » DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table
DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table [message #247926] Wed, 27 June 2007 09:52 Go to next message
mafc73
Messages: 38
Registered: November 2006
Member
Hi,

I have an IOT table with corrupt blocks. Can I use DBMS_REPAIR.SKIP_CORRUPT_BLOCKS to mark the corrupt blocks? I have a 10g database.

Thanks
Re: DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table [message #247945 is a reply to message #247926] Wed, 27 June 2007 10:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SKIP_CORRUPT_BLOCKS does not mark the blocks as corrupt, it just tell Oracle to skip corrupted blocks when it encounters one during scan.
To mark block as corrupted you have to use FIX_CORRUPT_BLOCKS but this does not work with IOT.

Regards
Michel
Re: DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table [message #247994 is a reply to message #247945] Wed, 27 June 2007 14:29 Go to previous messageGo to next message
mafc73
Messages: 38
Registered: November 2006
Member

Ok, but I only want to read all the records that it isn't corrupt. I want to do a "create table as select". Can I do this with DBMS_REPAIR.SKIP_CORRUPT_BLOCKS and a IOT table?

Thanks

Re: DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table [message #247997 is a reply to message #247994] Wed, 27 June 2007 14:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can try. It is not guaranteed it works.
Btw, you have no alternative, afaik.

Regards
Michel

[Updated on: Wed, 27 June 2007 14:35]

Report message to a moderator

Re: DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table [message #247999 is a reply to message #247926] Wed, 27 June 2007 14:44 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
There IS an alternative which is documented in a NOTE on Metalink
You can get the physical block number of the bad block & then SELECT
WHERE BLOCK# <> 1234

I know because I had to do this a couple of years ago.
Re: DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table [message #248001 is a reply to message #247999] Wed, 27 June 2007 14:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Wow, if you can remember the note number, it will be welcome.

Regards
Michel
Re: DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table [message #248004 is a reply to message #247926] Wed, 27 June 2007 14:54 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Just 'cuz your a Good Guy & went & searched MetaStink for it for you.

Subject: Handling Oracle Block Corruptions in Oracle7/8/8i/9i/10g
Doc ID: Note:28814.1
Re: DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table [message #248061 is a reply to message #248004] Wed, 27 June 2007 23:23 Go to previous message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oh yes, I thought you're talking about a pseudo-column BLOCK#.
It's the good olg rowid, of course. Embarassed

Regards
Michel
Previous Topic: Oracle DB and DATA file in different Drive (merged)
Next Topic: Oracle 10g versions
Goto Forum:
  


Current Time: Wed Dec 07 12:47:58 CST 2016

Total time taken to generate the page: 0.08903 seconds