3 Replies Latest reply on Dec 4, 2012 10:55 AM by Troll35

    Any view which tells partitioning_type is INTERVAL and not RANGE


      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.