Recent content by tatoo

  1. T

    In Browser Folder object_type = 'INDEX' returns nothing

    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)
  2. T

    In Browser Folder object_type = 'INDEX' returns nothing

    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?
  3. T

    In Browser Folder object_type = 'INDEX' returns nothing

    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.
Back
Top