Code assistant

[Arlindo Chirico Neto]

In Oracle 10g database with pl/sql developer
I'm trying view the object list of a owner less type her name before. It's possible? I'm not have public synonyms in the instance and will not.

 

[Marco Kalter]

This will only work if you are connected as the owner, or if there are private or public synonyms for these objects. In all other cases the object name without an owner is not a complete name.

 

[Claus Pedersen]

Hello Arlindo.

You can issue the command

ALTER SESSION SET CURRENT_SCHEMA = My_Schema

This will shift the context to another schema so all commands will be executed like you were logged on to My_Schema but with the rights with your current schema.