aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

ORA-14131: enabled UNIQUE constraint exists on one of the tables

ORA-14131: enabled UNIQUE constraint exists on one of the tables
Cause: One of the tables referenced in the ALTER TABLE EXCHANGE PARTITION|SUBPARTITION statement has enabled UNIQUE constraint(s) defined on it, which prevents EXCHANGE from proceeding.
Action: Disable constraints defined on tables referenced in the ALTER TABLE EXCHANGE PARTITION|SUBPARTITION statement and retry the statement.

请先 登录 后评论

1 个回答

小智
ORA-14131:enabled UNIQUE约束存在于其中一个表上,
.原因: ALTER TABLE EXCHANGE PARTITION | SUBPARTITION语句中引用的其中一个表已启用在其上定义的UNIQUE约束,这将阻止EXCHANGE继续执行。,
.操作:禁用在ALTER TABLE EXCHANGE PARTITION | SUBPARTITION语句中引用的表上定义的约束,然后重试语句。,
.
请先 登录 后评论