• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 413
  • Last Modified:

Use of DBMS_REPAIR in oracle 10.2.0.4

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
sharscho
Asked:
sharscho
1 Solution
 
slightwv (䄆 Netminder) Commented:
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
 
sharschoAuthor Commented:
I expected some advices from experts who had used this before and had experience with it. I had the link myself. Thanks anyways.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now