OraFAQ Forum: Server Administration » DBMS_REPAIR.SKIP_CORRUPT

Home » RDBMS Server » Server Administration » DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table [message #247926]

Wed, 27 June 2007 09:52

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

Report message to a moderator

Re: DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table [message #247945 is a reply to message #247926]

Wed, 27 June 2007 10:55

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table [message #247994 is a reply to message #247945]

Wed, 27 June 2007 14:29

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

Report message to a moderator

Re: DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table [message #247997 is a reply to message #247994]

Wed, 27 June 2007 14:35

Michel Cadot
Messages: 68686
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

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table [message #248001 is a reply to message #247999]

Wed, 27 June 2007 14:50

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table [message #248004 is a reply to message #247926]

Wed, 27 June 2007 14:54

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table [message #248061 is a reply to message #248004]

Wed, 27 June 2007 23:23

Michel Cadot
Messages: 68686
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 21:47:25 CDT 2024