SQL> alter table test_1 exchange with table test partition p_01_2007 ;
alter table test_1 exchange with table test partition p_01_2007
ORA-14155: 缺失 PARTITION 或 SUBPARTITION 关键字
SQL>
请问语法是什么样的?
帮助里好像没有 。
test为分区表
test_1为普通表白
SQL> alter table test_1 exchange partition p_01_2006 with table test;
alter table test_1 exchange partition p_01_2006 with table test
*
ERROR at line 1:
ORA-14501: object is not partitioned