table partition
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.