3 Replies Latest reply: Dec 4, 2012 4:49 AM by Saubhik RSS

    Any view which tells partitioning_type is INTERVAL and not RANGE

    user8941550
      Hi,

      I know that INTERVAL is a kind of RANGE partition.
      But if I want to find out explicitly from a 'SINGLE SQL STATEMENT' whether table is Interval partiioned or Range Partitioned.

      I tried:
      Select table_name, partitioning_type, partition_count from USER_PART_TABLES where table_name = 'TABLENAME'

      But is hows RANGE for both kinds of partitions.

      Thanks..