文档解释 ORA-14329: domain index [sub]partitions cannot be renamed in this clause Cause: The user tried to rename a domain i
ORA-14329: domain index [sub]partitions cannot be renamed in this clause
Cause: The user tried to rename a domain index [sub]partition in the UPDATE INDEXES clause of a ALTER TABLE MOVE [SUB]PARTITION operation. This is not allowed.
Action: Leave the name blank or use the same name.
ORA-14329 错误是指在此子句中,域索引分区不能重命名。
您正在尝试重命名域索引分区,但是这是不允许的。该sql语句会引发ORA-14329错误消息。
ORA-14329可以引发如下错误:
SQL> alter index emp_ind rename partition p1 to p2;
alter index emp_ind rename partition p1 to p2
*
ERROR at line 1:
ORA-14329: domain index [sub]partitions cannot be renamed in this clause
1.使用DROP PARTITION子句从表中删除该分区。
2.使用ADD PARTITION子句将具有新名称的分区添加回表中。
3.重建索引,使它可以识别新分区。
--结束END--
本文标题: ORA-14329: domain index [sub]partitions cannot be renamed in this clause ORACLE 报错 故障修复 远程处理
本文链接: https://www.lsjlt.com/news/529615.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0