| partition error [message #319092] |
Fri, 09 May 2008 00:51  |
balaji1482
Messages: 94
Registered: July 2007
Location: INDIA |
Member |
|
|
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
|
|
|
| Re: partition error [message #319193 is a reply to message #319092 ] |
Fri, 09 May 2008 05:20  |
JRowbottom
Messages: 2663
Registered: June 2006
Location: Sunny North Yorkshire, ho... |
Senior Member |
|
|
Try create table employee (
EmpNo number(10) primary key,
...
..
. |
|
|
]
Members
Search
Help
Register
Login
Home
