Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

table partition

241200Mar 19 2002
Hi, I am planning to create a table on different tablespaces using partition function. The syntax is as followings:
CREATE TABLE book
(in_date date NOT NULL,
book_no number(10,0) NOT NULL,
book_name VARCHAR2(60) NOT NULL,
author varchar2(40) NOT NULL,
Memo varchar2(100),
CONSTRAINT pk_book PRIMARY KEY
(book_no))
PARTITION BY RANGE(book_no)
(PARTITION PART1 VALUES LESS THAN (5000000000)
TABLESPACE "DATA"
PARTITION PART2 VALUES LESS THAN (10000000000)
TABLESPACE "DATA2"
);

but error occurs:ORA-14020
would you like help me? A lot thanks!
By the way, I run the scripts aboved on Oracle 805 and 817, and both failed.



Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2002
Added on Mar 19 2002
0 comments
147 views