partition error [message #319092] |
Fri, 09 May 2008 00:51 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
balaji1482
Messages: 312 Registered: July 2007 Location: INDIA
|
Senior Member |
![YES](/forum/theme/orafaq/images/yahoo.png)
|
|
hi guys,
i tried to create a table called employee with 4 partitions on it .but it shows me an error.
it would be great if u can revert me with the solution.
please find below the script error
SQL> create table employee
2 EmpNo number(10) primary key,
3 Name varchar2(40),
4 Deptno number(2),
5 salary number(7,2),
6 birth_date date,
7 soc_sec_num varchar(9), constraint FK_DEPTNO foreign key (DeptNo) references Dept(Deptno)
8 )
9 partition by range (Deptno)
10 (partition PART1 values less than (11)
11 tablespace PART1_TS,
12 (partition PART2 values less than (21)
13 tablespace PART2_TS,
14 (partition PART3 values less than (31)
15 tablespace PART3_TS,
16 (partition PART4 values less than (MAXVALUE)
17 tablespace PART4_TS);
EmpNo number(10) primary key,
*
ERROR at line 2:
ORA-00922: missing or invalid option
|
|
|
|