CREATE TABLE tabla (id NUMBER, FECHA DATE)
PARTITION BY RANGE (FECHA)
(PARTITION p1 VALUES LESS THAN (TO_DATE('2010-01-01', 'YYYY-MM-DD')),
PARTITION p2 VALUES LESS THAN (TO_DATE('2011-01-01', 'YYYY-MM-DD')),
PARTITION p3 VALUES LESS THAN (TO_DATE('2012-01-01', 'YYYY-MM-DD')),
PARTITION p4 VALUES LESS THAN (MAXVALUE)
)Table created.
CREATE VIEW TABLA_PART_RANGO
AS
SELECT table_name, partition_name, high_value
FROM user_tab_partitions
WHERE table_name = 'TABLA'View created.
SELECT * FROM TABLA_PART_RANGO
| TABLE_NAME | PARTITION_NAME | HIGH_VALUE | TABLA | P1 | TO_DATE(' 2010-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') | TABLA | P2 | TO_DATE(' 2011-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') | TABLA | P3 | TO_DATE(' 2012-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') | TABLA | P4 | MAXVALUE |
|---|