Setting up browser folders

[Ron]

Trying to set up browser folder for DIMENSION objects. It appears that they are not part of the sys.all_objects view. User has DBA privileges. Any advice?

 

[davemans]

I think it is because there is no icon for a dimension. You can get them to display as tables by putting the following in the where clause for your folder :-
owner = 'Dummy'
union all
select owner, 'TABLE', object_name, status
from all_objects
where owner = USER
and object_type = 'DIMENSION'

 

[Ron]

Thanks for the help.

Using your query, I set up a new browser folder icon for dimensions. In the where clause I inserted

object_type = 'DIMENSION'
union
select owner, 'TABLE', object_name, status
from all_objects
where owner = USER
and object_type = 'DIMENSION'

The new folder now contains the dimensions. Obviuosly PL/SQL Developer doesn't recognize a dimension object type.