Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 408
  • 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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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