The create table g_emp (
Empno number (4) primary key,
Ename char (10),
Job char (10),
MGR number (4),
Hiredate date,
Sale number (7, 2),
Comm number (3, 2),
Deptno number (8, 3)
)
Partition by range (sale)
(
Partition p1 values less than (1000) in tablespace tbs1,
Partition p2 values less than (2000) in tablespace tbs2,
Partition p3 values less than (3000) in tablespace tbs3,
Partition p4 values less than (4000) in tablespace tbs4,
Partition the p5 values less than (5000) in tablespace tbs5,
Partition p6 values less than (maxvalue) in tablespace tbs6,
);
Displays an error pritition missing keywords, sprout new consult!

CodePudding user response:

P6 this partition, and finally the comma,

CodePudding user response:

Tbs6 much behind a comma,

CodePudding user response:

Sale number (7, 2), this is not the integer, decimal, sale try whether this problem into an integer

CodePudding user response:

Or partition in the partition field by range (sale) add a function is rounded

CodePudding user response:

If to knot posted,