例如:表 emp有坏块
alter table emp rename to corrupt_emp;
alter session set events '10231 TRACE NAME CONTEXT FOREVER,LEVEL 10';
create table emp as select * from corrupt_emp;
alter table emp rename to corrupt_emp;
alter session set events '10231 TRACE NAME CONTEXT FOREVER,LEVEL 10';
create table emp as select * from corrupt_emp;
1、将数据文件脱机--
ALTER DATABASE
DATAFILE 'filename' OFFLINE;
2、还原数据库--
ALTER DATABASE RENAME FILE
'old_filename' TO 'new_filename';
3、恢复文件--
RECOVER DATAFILE 'filename';
4、将文件重新联机--
ALTER DATABASE
DATAFILE 'D:\...\filename'
ONLINE;