如题,建立一个分区表,并建立同义词
CREATE TABLE PAR_TEST2
(
"ID" NUMBER,
"OWNER" VARCHAR2(30),
"OBJECT_NAME" VARCHAR2(30),
"CREATED" DATE
)
PARTITION BY RANGE ("ID")
(
PARTITION "P1"VALUES LESS THAN (1000) ,
PARTITION "P2"VALUES LESS THAN (2000) ,
PARTITION "P3"VALUES LESS THAN (3000)
);
create or replace synonym PAR_TEST for par_test2;
然后尝试使用该同义词进行分区管理操作
以下SQL可以正常执行
alter table par_test add partition pmax values less than (maxvalue);
alter table par_test split partition pmax at (4000) into (partition p4,partition pmax);
alter table par_test split partition pmax at (5000) into (partition p5,partition pmax);
alter table par_test move partition p1 tablespace master_data;
alter table par_test merge partitions p1,p2 into partition p2;
select count(*) from par_test partition (p2);
以下SQL报错:ORA-00942: table or view does not exist
alter table par_test drop partition p2;
alter table par_test truncate partition p2;
alter table par_test rename partition p2 to p1000;
P.S 以上操作均在同一用户下执行
问题:在分区表上建立同义词之后,为什么有些命令可以,有些不可以了呢?
|