ORA-14402: Updating partition key column would cause a partition change[@more@]
今天遇到这个分区表的问题。
解决方法为:
select TABLE_NAME, ROW_MOVEMENT from dba_tables where partitioned = 'YES' ORDER BY ROW_MOVEMENT
alter table salary.ps_overtime enable row movement;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/60217/viewspace-977524/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/60217/viewspace-977524/