ORA-10631: SHRINK clause should not be specified for this object
Cause: It is incorrect to issue shrink on the object
Action: Verify the object name and type and reissue the command
:
ORA-10631是Oracle数据库报错,由于使用者在操作某个对象时使用了“SHRINK”子句,而数据库引擎发现该对象并不支持SHRINK操作,于是报这个错误。
ORA-10631: SHRINK clause should not be specified for this object
Cause: A SHRINK clause was specified in an ALTER statement on an object that cannot be shrunk.
Action: No action is required. SHRINK clause is a no-op. The statement can be re-executed without the clause.
一般由于误操作,把“SHRINK”子句用在不该用的对象上而引起。
1. 分析对象,检查是否支持SHRINK子句操作。
2. 如果不支持SHRINK子句操作,则将SHRINK子句移除。
3. 再重新提交即可。