1.因为工作需要,需要将CAMS_CORE用户下的表做一次表空间迁移,生成迁移命令脚本如下:
select 'alter table CAMS_CORE.'|| TABLE_NAME || ' move tablespace cams_core_tab;' from dba_tables where owner='CAMS_CORE';
2.将生成的语句进行迁移,其中有2个表为Interval Partition分区表,迁移时遇到了问题:
alter table CAMS_CORE.BP_VOUCHER_RECENT move tablespace cams_core_tab;
alter table CAMS_CORE.BP_VOUCHER_HISTORY move tablespace cams_core_tab;
提示错误
ORA-14511: cannot perform operation on a partitioned object
3.使用oerr查看错误信息
[oracle@XLJ181 dump]$ oerr ORA 14511 14511, 00000, "cannot perform operation on a partitioned object" // *Cause: An attempt was made to perform an operation that is not