Quote:
Originally posted by aarroyob
Hi,
The corruption appears in some situations, dbv, export ...
Oracle reformat all blocks when it use, but in indexes case not. Then you can drop the index, create a temporary table on index tablespace, insert data in this table, and when Oracle gets this corrupted block it will format. Then you will drop the temporary table and recreate the index.
Hope that helps
Angel
i don't think loading data to a predefined block is possible. This is managed internally by Oracle (based on freelists. )