ORA-31441: table is not a change table

ORA-31441: table is not a change table
Cause: User attempted to execute the DROP_CHANGE_TABLE procedure on a table that is not a CHANGE table. This can also occur when a CHANGE table object has been orphaned. CHANGE tables can become orphaned after a CREATE_CHANGE_TABLE failure or an incomplete DROP_CHANGE_TABLE.
Action: Check spelling. If error was due to an incorrect name, then retry the procedure using the correct name. To drop a table that is not a CHANGE table, or an orphaned CHANGE table, use the DROP TABLE DDL command instead.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:49

ORA-31441：表不是更改表,
.原因：用户尝试对不是CHANGE表的表执行DROP_CHANGE_TABLE过程。当CHANGE表对象被孤立时，也可能发生这种情况。CHANGE表在CREATE_CHANGE_TABLE失败或不完整的DROP_CHANGE_TABLE后可能成为孤立的。,
.操作：检查拼写。如果错误是由于名称不正确，请使用正确的名称重试该过程。要删除非CHANGE表或孤立的CHANGE表的表，请改用DROP TABLE DDL命令。,
.

aiaiDBA

13718043309

010-86462881

ORA-31441: table is not a change table

1 个回答

相似问题