ORA-10631: SHRINK clause should not be specified for this object

文档解释

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. 再重新提交即可。

你可能感兴趣的