Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- > DROP TABLE iotrange
- TABLE IOTRANGE dropped.
- > CREATE TABLE iotrange
- (
- d DATE,
- n NUMBER,
- CONSTRAINT iotrange_pk PRIMARY KEY ( d,n )
- )
- ORGANIZATION INDEX
- PARTITION BY RANGE ( d )
- (
- PARTITION p2014 VALUES less than (TO_DATE('2015-01-01','yyyy-mm-dd'))
- )
- TABLE IOTRANGE created.
- > DROP TABLE heapinterval
- TABLE HEAPINTERVAL dropped.
- > CREATE TABLE heapinterval
- (
- d DATE,
- n NUMBER,
- CONSTRAINT heapinterval_pk PRIMARY KEY ( d,n )
- )
- PARTITION BY RANGE ( d ) INTERVAL (INTERVAL '1' DAY)
- (
- PARTITION p2014 VALUES less than (TO_DATE('2015-01-01','yyyy-mm-dd'))
- )
- TABLE HEAPINTERVAL created.
- > CREATE TABLE iotinterval
- (
- d DATE,
- n NUMBER,
- CONSTRAINT iotinterval_pk PRIMARY KEY ( d,n )
- )
- ORGANIZATION INDEX
- PARTITION BY RANGE ( d ) INTERVAL (INTERVAL '1' DAY)
- (
- PARTITION p2014 VALUES less than (TO_DATE('2015-01-01','yyyy-mm-dd'))
- )
- Error starting AT line 29 IN command:
- CREATE TABLE iotinterval
- (
- d DATE,
- n NUMBER,
- CONSTRAINT iotinterval_pk PRIMARY KEY ( d,n )
- )
- ORGANIZATION INDEX
- PARTITION BY RANGE ( d ) INTERVAL (INTERVAL '1' DAY)
- (
- PARTITION p2014 VALUES less than (TO_DATE('2015-01-01','yyyy-mm-dd'))
- )
- Error AT Command Line:37 COLUMN:1
- Error report:
- SQL Error: ORA-25198: only RANGE, list, AND hash partitioning are supported FOR index-organized TABLE
- 25198. 00000 - "only range, list, and hash partitioning are supported for index-organized table"
- *Cause: SYSTEM, OR Composite partitioning schemes are NOT supported yet
- *Action: SELECT a different partitioning scheme
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement