表结构+分区设置:
CREATE TABLE T_EVENT (
Evn_ID VARCHAR2(32CHAR) NOT NULL,
DEPT_NO VARCHAR2(6CHAR),
CRE_TIME DATE
)
partition by range(CRE_TIME) subpartition by list (DEPT_NO)
(
partition pt1 values less than(to_date('2017-10-01','yyyy-mm-dd'))
(
subpartition pi1 values ('100'),
subpartition pi2 values ('200'),
subpartition pi3 values ('300')
)
);
上面是表结构,下面是两种分区操作
增加分区
ALTER TABLE T_EVent ADD PARTITION pt2 values less than(to_date('2007-10-2','yyyy-mm-dd'))
(
subpartition pi4 values ('100'),
subpartition pi5 values ('200'),
subpartition pi6 values ('300')
);
删除分区
alter table t_event truncate partition pt1
alter table t_event drop partition pt1
请问:如何在Shell脚本中对上面两种操作是否成功进行判断?