Enhancement Request : Partitioned Tables

[orca777]

Hi DevTeam;

would like to have support for table partitions in the object browser as additional folder (Partitions);
Also would like to have a slighley different symbol for partitioned tables;

cheers
Karl

 

[Joachim Rupik]

Hello Karl,

You can create a custom folder (named Tables - partitioned) with the following where clause:

object_type = 'PARTITION'
union
select t.owner, 'TABLE' object_type, t.table_name object_name, o.status
from all_tables t, all_objects o
where t.owner = o.owner
and t.table_name = o.object_name
and o.object_type = 'TABLE'
and t.partitioned = 'YES'
and o.owner = USER

It will shows any partitioned table only.

 

[orca777]

thx,
but are the partitions visible in a sub-folder of it?
-> No!
so we need still native support for partioned tables.

Greetings Joachim
Karl