SQL>  select * from audit_trail;

TS                                   DATA

-----------------------------------  -----------

22-FEB-10  12.00.00.000000 AM        lss

27-MAR-10  12.00.00.000000 AM        xysoul

12-MAY-10  12.00.00.000000 AM        lss

07-JUL-10  12.00.00.000000 AM        lss

SQL>  rollback;

Rollback  complete.

SQL>  select * from audit_trail;

no rows  selected

SQL> col  INVERTAL for a40

SQL> col  HIGH_VALUE for a35

SQL> set  lines 999

SQL> col tablespace_name  for a20

SQL> col  PARTITION_NAME for a15

SQL>  select a.partition_name,a.tablespace_name,a.high_value,

     decode(a.interval,'YES',b.interval) invertal

     from user_tab_partitions a,user_part_tables b

     where a.table_name='AUDIT_TRAIL'

     and a.table_name=b.table_name

     order by a.partition_position;

PARTITION_NAME   TABLESPACE_NAME       HIGH_VALUE                           INVERTAL

---------------  -------------------- -----------------------------------  ----------------------------------------

P0               USERS                 TIMESTAMP' 2010-01-01 00:00:00'

SYS_P64          USERS                 TIMESTAMP' 2010-03-01 00:00:00'      NUMTOYMINTERVAL(1,'MONTH')

SYS_P61        TABLESPACEA             TIMESTAMP'  2010-04-01 00:00:00'     NUMTOYMINTERVAL(1,'MONTH')

SYS_P63        TABLESPACEA              TIMESTAMP' 2010-06-01 00:00:00'      NUMTOYMINTERVAL(1,'MONTH')

SYS_P62          TABLESPACEA              TIMESTAMP' 2010-08-01 00:00:00'      NUMTOYMINTERVAL(1,'MONTH')