create table ZDEVICE_BAT
(
INFOID INTEGER not null,
DEVICENO VARCHAR2(32),
RECEIVETIME TIMESTAMP(0),
LONGITUDE NUMBER(20,6),
LATITUDE NUMBER(20,6)
)
partition by list (DEVICENO)
(
partition Z283354 values ('283354') ,
partition Z281693 values ('281693') ,
partition Z285004 values ('285004')
);老报这样的错误 ORA-14004: missing PARTITION keyword
请大侠指点为什么?
(
INFOID INTEGER not null,
DEVICENO VARCHAR2(32),
RECEIVETIME TIMESTAMP(0),
LONGITUDE NUMBER(20,6),
LATITUDE NUMBER(20,6)
)
partition by list (DEVICENO)
(
partition Z283354 values ('283354') ,
partition Z281693 values ('281693') ,
partition Z285004 values ('285004')
);老报这样的错误 ORA-14004: missing PARTITION keyword
请大侠指点为什么?
--没出现你说的情况啊?
--是不是你在敲代码的时候,单词敲错了还是......
SQL> create table ZDEVICE_BAT
2 (
3 INFOID INTEGER not null,
4 DEVICENO VARCHAR2(32),
5 RECEIVETIME TIMESTAMP(0),
6 LONGITUDE NUMBER(20,6),
7 LATITUDE NUMBER(20,6)
8 )
9 partition by list (DEVICENO)
10 (
11 partition Z283354 values ('283354') ,
12 partition Z281693 values ('281693') ,
13 partition Z285004 values ('285004')
14 );Table created