Home » RDBMS Server » Server Administration » partition error (10g)
partition error [message #319092] Fri, 09 May 2008 00:51 Go to next message
Messages: 312
Registered: July 2007
Location: INDIA
Senior 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 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
create table employee (
EmpNo number(10) primary key,
- added a "("
Previous Topic: some problem in database creation
Next Topic: problem in dropping a database
Goto Forum:

Current Time: Mon Oct 24 02:17:22 CDT 2016

Total time taken to generate the page: 0.08713 seconds