Oracle数据库坏块(corruption)-物理坏块(二)

40 OPERATIONS? ? BOSTON

5.2 方法#2 DBMS_REPAIR.SKIP_CORRUPT_BLOCKS跳过坏块，然后将dept表中的其他数据导出重建表

SQL> alter session set db_file_multiblock_read_count=1;

SQL> execute DBMS_REPAIR.SKIP_CORRUPT_BLOCKS('JAMES','DEPT');

SQL> create table dept_new as select * from dept;