/*==============================================================*/
/* Table: T_PERF_CELL_G */
/*==============================================================*/
create global temporary table OCMDB2.T_PERF_CELL_G (
START_TIME DATE not null,
MONITORID NUMBER,
CITY_ID NUMBER,
NETTYPE NUMBER not null,
NE_SYS_ID CHAR(16) not null,
CHINA_NAME VARCHAR2(64),
CI NUMBER,
LAC NUMBER,
PERF_ROWID ROWID
)
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
freelists 1
freelist groups 1
)
nologging
noparallel
/
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
freelists 1
freelist groups 1
)
nologging
// *Cause: An attempt was made to create an IOT, specify physical attributes,
// specify partition or parallel clause.
// *Action: do not do that.不支持的临时表特征。---------------------------
specify physical attributes:不能定义它的物理属性。如楼上所说,不能指定临时表的各种物理存储参数。