Oracle表增加分区报错"ORA-14760"
Database: 11g Release 2
Error code: ORA-14760
Description: ADD PARTITION is not permitted on Interval partitioned objects
Cause: ALTER TABLE ADD PARTITION was attempted on an Interval partitioned object.
Action: Do not perform the operation on an Interval partitioned object. Insert a row to create the new partition.
大概意思是间隔分区表只需要插入行就可以新建分区了,经测试插入数据时可以自动分区,并且创建表时无 INTERVAL (numtoyminterval(1, ‘year’)分区间隔语句,但是会造成分区名不统一。
原文链接:https://www.oraexcel.com/oracle-11gR2-ORA-14760
在网上查资料时有 1.无maxvalue分区2.有maxvalue分区 两种情况增加分区的方式
对表增加maxvalue分区时依然报ORA-14760!
ALTER TABLE XX SET INTERVAL ()
后来还是发现创建表时设置了interval,禁用INTERVAL就好啦,缺点插入数据时不会自动分区
https://www.cnblogs.com/Bkdgl/p/10097299.html