Feature request: partitions/subpartitions listing

[-IceTea-]

1) When a table has subpartitions and not only partitions, the partitions tab is not shown at all which is confusing and can cause someone to think that the table is in fact not partitioned at all - I suggest putting a tab for partitions as well as a tab for subpartitions (for each relevant table type of course).

2) partitions/subpartitions should be in the object tree view of the table/index, where subpartitions are nested under a specific partition, with an icon indicating their type (The subpartition/partition's type, that is).

These two things would REALLY help lots of people as the only way to see partitions on a partitioned table is either to use "GET DDL" which is ugly and not convenient or going to "view table", but anyway, this only works for partitioned tables and not subpartitioned tables, so for these the only option is the "GET DDL" option or running a query in an SQL window every time which is really annoying.

 

[Marco Kalter]

This is on the list of enhancement requests.

 

[-IceTea-]

Thanks,
Is there a way to look at this list so I do
not post something that has already been suggested?

 

[DoDo]

"Is there a way to look at this list so I do
not post something that has already been suggested?"

For me too, please!

 

[Joachim Rupik]

You can define your own custom browser folder.
In a where clause put the following code:

object_type = 'PARTITION'
union
select pt.owner, o.object_type, pt.table_name, o.status
from all_part_tables pt, all_objects o
where o.owner = USER
   and pt.owner = o.owner
   and pt.table_name = o.object_name
   and o.object_type = 'TABLE

You can also use a Browser Extender extension - "Partition clause Regenerator" to regenerate patritions definition for selected table.

Please read more on Browser Extender site.

 

[-IceTea-]

Thanks!