create table
interval_par_demo (
start_date DATE,
store_id NUMBER,
inventory_id NUMBER(6),
qty_sold NUMBER(3)
)
PARTITION BY RANGE (start_date)
INTERVAL(NUMTOYMINTERVAL(1, 'MONTH'))
(
PARTITION interval_par_demo_p2 VALUES LESS THAN (TO_DATE('1-7-2007', 'DD-MM-YYYY')),
PARTITION interval_par_demo_p3 VALUES LESS THAN (TO_DATE('1-8-2007', 'DD-MM-YYYY'))
)Table created.
insert into interval_par_demo (start_date, store_id, inventory_id, qty_sold)
values ( '15-AUG-07', 1, 1, 1)1 row(s) inserted.
insert into interval_par_demo (start_date, store_id, inventory_id, qty_sold)
values ( '15-SEP-07', 1, 1, 1)ORA-01536: space quota exceeded for tablespace 'LIVE_SQL_TABLESPACE'
SELECT
TABLE_NAME,
PARTITION_NAME,
PARTITION_POSITION,
HIGH_VALUE
FROM
USER_TAB_PARTITIONS
WHERE
TABLE_NAME='INTERVAL_PAR_DEMO'
ORDER BY
PARTITION_NAME| TABLE_NAME | PARTITION_NAME | PARTITION_POSITION | HIGH_VALUE |
|---|---|---|---|
| POS_DATA | POS_DATA_P2 | 1 | TO_DATE(' 2007-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') |
| POS_DATA | POS_DATA_P3 | 2 | TO_DATE(' 2007-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') |
| POS_DATA | SYS_P81 | 3 | TO_DATE(' 2007-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') |