sql> select partitioned from dba_tables where table_name='lytusage';
par
---
yes
sql> select partition_name,high_value from dba_tab_partitions where table_name='lytusage';
partition_name high_value
------------------------------ --------------------------------------------------------------------------------
lytusage_200401 to_date(' 2004-02-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200402 to_date(' 2004-03-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200403 to_date(' 2004-04-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200404 to_date(' 2004-05-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200405 to_date(' 2004-06-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200406 to_date(' 2004-07-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200407 to_date(' 2004-08-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200408 to_date(' 2004-09-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200409 to_date(' 2004-10-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200410 to_date(' 2004-11-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200411 to_date(' 2004-12-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200412 to_date(' 2005-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200501 to_date(' 2005-02-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200502 to_date(' 2005-03-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200503 to_date(' 2005-04-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200504 to_date(' 2005-05-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200505 to_date(' 2005-06-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200506 to_date(' 2005-07-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200507 to_date(' 2005-08-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200508 to_date(' 2005-09-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200509 to_date(' 2005-10-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200510 to_date(' 2005-11-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
lytusage_200511 to_date(' 2005-12-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregoria
