This discussion is archived
3 Replies Latest reply: Dec 4, 2012 2:49 AM by Saubhik RSS

Any view which tells partitioning_type is INTERVAL and not RANGE

user8941550 Newbie
Currently Being Moderated
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..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points