In Browser Folder object_type = 'INDEX' returns nothing

[tatoo]

Hi,
Why in Browser Folder (PSD v7.1.5) object_type = 'INDEX' returns nothing?
if i try object_type = 'TABLE' or object_type = 'VIEW' it works ok.

 

[Marco Kalter]

In version 7.1 the INDEX object type was not supported for user-defined folders. In 8.0 and later this is supported.

 

[tatoo]

Hi,
I have upgraded now to PSD v9.0.6 and still have the same issue

I want to view in the browser folder all partitioned Indexes and partitioned tables.
Filters on object_type = 'INDEX PARTITION' or object_type = 'TABLE PARTITION' seems not work too...
Is there any workarounds?

 

[Marco Kalter]

To create a folder with partitioned tables, you can use a where clause like this:

object_type = 'TABLE' and
exists (select * from all_tables t
         where t.partitioned = 'YES'
           and t.owner = all_objects.owner
           and t.table_name = all_objects.object_name)

 

[tatoo]

Yes, it works for TABLES but something like that doesn't work for INDEXES:

object_type = 'INDEX'
and exists (select * from all_indexes t
            where t.PARTITIONED = 'YES'
            and t.OWNER = all_objects.owner
            and t.INDEX_NAME = all_objects.object_name)

 

[Marco Kalter]

It does indeed not seem to work for indexes, regardless whether they are partitioned or not. This seems like a bug. We'll fix it.