ORA-14094: invalid ALTER TABLE EXCHANGE PARTITION option

ORA-14094: invalid ALTER TABLE EXCHANGE PARTITION option
Cause: Name of the table to be EXCHANGED has to be followed by [{INCLUDING|EXCLUDING} INDEX][{WITH|WITHOUT} VALIDATION]
Action: Ensure that no options besides INCLDING INDEX or EXCLUDING INDEX are specified with ALTER TABLE EXCHANGE PARTITION

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

ORA-14094：无效的ALTER TABLE EXCHANGE PARTITION选项,
.原因：要被EXCHANGED的表的名称后面必须是[{INCLUDING | EXCLUDING} INDEX] [{WITH | WITHOUT} VALIDATION],
.操作：确保除了INCLDING INDEX或EXCLUDING INDEX之外，没有使用ALTER TABLE EXCHANGE PARTITION,
.

aiaiDBA

13718043309

010-86462881

ORA-14094: invalid ALTER TABLE EXCHANGE PARTITION option

1 个回答

相似问题