welmablossom
|
dbms_repair utility provides a mechanism to repair the corrupted database blocks, the fix_corrupt_blocks procedure. Below listed is the syntax for the fix_corrupt_blocks procedure:
dbms_repair.FIX_CORRUPT_BLOCKS (
schema_name IN VARCHAR2,
object_name IN VARCHAR2,
partition_name IN VARCHAR2 DEFAULT NULL,
object_type IN BINARY_INTEGER DEFAULT TABLE_OBJECT,
repair_table_name IN VARCHAR2 DEFAULT 'REPAIR_TABLE',
flags IN BINARY_INTEGER DEFAULT NULL,
fix_count OUT BINARY_INTEGER);
Try running this procedure it might help. If it does not then I think you need to go for any oracle repair software third party software program that will do the job of repairing the oracle database tables. Software is easy to use and no prior technical skills are required. So, just try out the above steps if that does not work then go for this software program.
 Posted 116 days ago
|