新增临时表报错 :ORA-14451:不受支持的临时表功能,求助

[iversonlzy]

/*==============================================================*/
/* 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
/

[wqkjj]

14451, 00000, "unsupported feature with temporary table"
// *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：不能定义它的物理属性。如楼上所说，不能指定临时表的各种物理存储参数。

[小德]

貌似是把这些去掉才行
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
freelists 1
freelist groups 1
)
nologging