文档解释 ORA-00212: block size string below minimum required size of string bytes Cause: The block size specified was too sm
ORA-00212: block size string below minimum required size of string bytes
Cause: The block size specified was too small. Space for the system overhead is required.
Action: Specify a larger block size and retry the operation.
。
ORA-00212: 表示磁盘上的块大小小于系统所需要的最小块大小。
1.查看TableSpace块大小:
SELECT (initial_extent * sys_op_block_size) FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = ‘MYTABLESPACE’;
2.查看oracle所需的最小块大小:
SELECT value from V$PARAMETER WHERE name = ‘db_block_size’;
3.(可选)修改块大小:
ALTER DATABASE DATAFILE ‘/path/to/datafile’ RESIZE new_size;
--结束END--
本文标题: ORA-00212: block size string below minimum required size of string bytes ORACLE 报错 故障修复 远程处理
本文链接: https://www.lsjlt.com/news/540380.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0