TYPES

Toad for Oracle
1

Toad will not show types owned by specific schema. It only shows types owned by sys. Seems to depend on having synonyms on types. Oracle gets synonyms for types without any problem.

I’m using toad 12.1 64 bit under windows7, oracle 12.1 under suse linux.

Does anybody know this as a toad bug?

thanks for help

Wilko

2

If you log in as the owner of the types, Toad will select from USER_TYPES and USER_OBJECTS. If you want to see types from a different schema, Toad users DBA_TYPES and DBA_OBJECTS if you have privileges to select from them (sounds like you don’t), otherwise ALL_TYPES and ALL_OBJECTS.

The ALL_ views only show objects that you have privileges on, so maybe that is the problem.