ORA-01578 ORACLE data block corrupted (file # string, block # string) Cause :
The data block indicated was corrupted, probably due to program errors. Action :
Determine which object was corrupted using a command like the following: SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME FROM DBA_EXTENTS WHERE file = FILE_ID AND block BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS -1; where values for file and block are from the message. Try to restore the segment containing the block indicated. This may involve dropping the segment and re-creating it. If there is a trace file, report the errors in it to Oracle Customer Support
The data block indicated was corrupted, probably due to program errors. Action :
Determine which object was corrupted using a command like the following: SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME FROM DBA_EXTENTS WHERE file = FILE_ID AND block BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS -1; where values for file and block are from the message. Try to restore the segment containing the block indicated. This may involve dropping the segment and re-creating it. If there is a trace file, report the errors in it to Oracle Customer Support
解决方案 »
- Oracle数据导入中遇到的问题
- Oracle存储过程的几个问题,望指教
- 求一sql的写法,将多条记录拼成一条记录
- ORACLE 储存过程绑定变量
- 在Oracle中删除某条记录时怎样用触发器实现主键(为编号)大于删除的这条所有的编号怎样减1
- 一个关于Oracle的初学者问题....
- ORA-00905:缺少关键字
- 我在保存一个表的数据时,有时无法保存,系统提示'ora-01041内部错误,hostdef扩展名不存在‘,这是为什么?
- execute immediate使用
- 怎么用脚本给postgresql数据库所有表加同一个字段的索引
- 菜鸟求助高手ing,回滚段的作用是什么?
- 求更高效率的自连接sql语句
http://www.dbonline.cn/source/oracle/20040216/BACKUP_Oracle%20bad%20block%20resolving.html