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怎么配置环境。。。。着急在线等
- 安装在XP系统中出现的问题
- PL/SQL 创建触发器问题
- 数据库TURNING的,老难题,高手请进
- 热心人帮我查一下:Error: PL/SQL: ORA-00600: 内部错误代码,参数: [qcscpqbc1], [1], [0], [], [], [], [], []
- [求助]提取表内的数据进行计算,结果列再插入这个表能实现吗,用视图还是普通的表就可以阿?
- || 是什么运算符?
- 关于一个储存过程的错误,请高手指点!!
- ORACLE中DATE类型查询问题?
- 求教一条生成日期范围的SQL语句?
- 菜鸟求助高手ing,回滚段的作用是什么?
- 求更高效率的自连接sql语句
http://www.dbonline.cn/source/oracle/20040216/BACKUP_Oracle%20bad%20block%20resolving.html