(wrong string) – range or interval?

From: <zigzagdna_at_yahoo.com>
Date: Sat, 2 May 2009 05:14:48 -0700 (PDT)
Message-ID: <acd2b782-8009-4ae3-8a01-591ff1f60254_at_21g2000vbk.googlegroups.com>



On May 1, 10:53 pm, zigzag..._at_yahoo.com wrote:
> I have a table which is interval partitioned. It has several range
> partitions and several interval partitions. Is there any way to find
> which partitions are range and which are interval.  I looked in
> user_part_tables, it does not give me all partitions of the table.
> User_tab_partitions shows me all partitions, but does not tell
> partitioning_type.
>
> I am playing with merging of partitions in interval partioned tables
> and wanted to see which partions are range after merging, but could
> not find a way.

I tried join between dba_tab_partitions and dba_part_tables but partioning_type returned in always range, so there does not seem to distincuish range from iterval. Received on Sat May 02 2009 - 07:14:48 CDT

Original text of this message