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!

ORA-14020

lesakJul 1 2010 — edited Jul 2 2010
I try to create partition table like in listing below:
CREATE TABLE SOME_TABLE
  (
    COL1 NUMBER(2),
    COL2 VARCHAR(45),
    .
    .
    COLXX VARCHAR(30)
  ) 
   PARTITION BY RANGE(COL1) SUBPARTITION BY HASH(COL2)
   (PARTITION part_less_2 VALUES LESS THAN (2) TABLESPACE tbs_1
    PARTITION part_less_11 VALUES LESS THAN (11) TABLESPACE tbs_2
    PARTITION part_maxval VALUES LESS THAN (MAXVALUE) TABLESPACE tbs_3);
Could someone explain me why I've got ORA-14020 as an output?
This post has been answered by Boochi on Jul 1 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 30 2010
Added on Jul 1 2010
5 comments
2,000 views