Solved

Use of DBMS_REPAIR in oracle 10.2.0.4

Posted on 2011-09-09
2
395 Views
Last Modified: 2012-05-12
Hi experts,

 I am experiencing a problem with a table that has corrupted blocks. The dbms_repair tool in oracle 8i and 9i was only marking the corrupted blocks and skipping them. That is not good for me in this situation. I heard that in oracle 11i it does much more. But my question is does it do more in oracle 10i also? Can someone telle me what the dbms_repair does in oracle 10i.
0
Comment
Question by:sharscho
2 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 36510237
I would always start in the docs:
Using DBMS_REPAIR to Repair Data Block Corruption

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/repair.htm#ADMIN022
0
 

Author Closing Comment

by:sharscho
ID: 36519649
I expected some advices from experts who had used this before and had experience with it. I had the link myself. Thanks anyways.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question