发现一个奇葩的问题:

oracle中创建分区时,如果在plsql developer的command window中写sql,则分区之间的sql语句不能空行;如果在sql window中写建表sql,则可以空行

create table t_sagw_transferset_msg
(
TIME TIMESTAMP(3),
MSGTYPE VARCHAR2(20),
APPKEY VARCHAR2(20),
APPCODE VARCHAR2(20),
MSGDGT VARCHAR2(80),
TS TIMESTAMP(3),
REQUESTID VARCHAR2(64),
ACTION VARCHAR2(1),
TELX VARCHAR2(20),
BLACKS VARCHAR2(200),
CODE VARCHAR2(20),
DELAY NUMBER
)
partition by range(TIME)
(
partition P20171226 values less than (TIMESTAMP' 2017-12-27 00:00:00')
tablespace SMB_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1在sqlwindow中无此问题
partition P20171227 values less than (TIMESTAMP' 2017-12-28 00:00:00')
tablespace SMB_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
)
);