请教怎样交换分区,即怎样使用exchange命令？

[kentenjoy]

有两个表
create table sales(
invoice_no number,
sale_year int not null,
sale_month int not null,
sale_day int not null)
partition by range(sale_year)
(partition sales_q1 values less than(2002)
tablespace taba ）;

create table sales(
invoice_no number,
sale_year int not null,
sale_month int not null,
sale_day int not null) tablespace tabb;

alter table sales exchange partition sales_q1 with table sales1;
报错为
ERROR at line 1:
ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
请高手指教，谢谢

[kentenjoy]

up

[liuyi8903]

没看到你有sales1表啊.
如:
alter table t
exchange partition part2004
with table t3

[kentenjoy]

up