corrupted block

[nach]

hi guys
what might be the cause if you keep on gettin ora:1578(corrupt block) error after rebuilding the index?...it takes me to a different block # after rebuilding the previous index.

[aarroyob]

Hi,

The rebuild command doens´t format the block. I think the only solution is to recover from backup or do the next:

1. Drop your index
2. Create a temporary table
3. Load data into temporary table until the corruption is corrected.
4. Create your index

But, in this way you cannot know when you will get the corrupted block, then ... maybe you will get the last block ...

Hope that helps

Angel

[SANJAY_G]

Before droppping and recreating the index make sure which object is corrupt. Run the qeury below to find out which object is corrupt?

SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME FROM DBA_EXTENTS
WHERE file = FILE_ID AND block BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS -1;

Hope this helps.

Sanjay

[nabaig]

I think an easier way would be to:

1. Drop index.
2. Export the table.
3. Import it back.
4. Recreate the index.

Export check for block corruption errors.
If I am wrong about this, please correct me.

Nizar

[sanjaygk]

Hi,

you have said that your index is corrupted.
then drop the index and recreate or rebuild the index in a diffenent tablespace.
if you have any primary key constraints then disable then rebuild the index after creating then enable the constraint.

you can use dbv file='' logfile=name.out to find how many blocks are corrupted.


take care

sanjay