Home » RDBMS Server » Server Administration » partition error (10g)
partition error [message #319092] Fri, 09 May 2008 00:51 Go to next message
balaji1482
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
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Try
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: Sat Dec 10 12:51:12 CST 2016

Total time taken to generate the page: 0.04543 seconds