Context with schema and synonym with the same name

tvergote

Member
I have the following problem :
There is a view called "KALENDER" in one schema that has a public synonym that is also called "KALENDER"
Then there is also a schema called "KALENDER".

The result in PL/SQL developer is that the context of any table/view in the KALENDER schema refers to the "KALENDER" view.
For example : i create an SQL window with

SELECT * from KALENDER.TABLE_NAME;

And right-click on KALENDER.TABLE_NAME and ask for a describe, and I get the describe of the KALENDER view instead of KALENDER.TABLE_NAME .

If i find the tables/views trough object-browser, then it does work correctly.

I have the problem both in version 11 and 12 (Version 11.0.6.1776 and Version 12.0.1.1814 (32 bit) )

 
The same as right-click without selecting : the context refers to the KALENDER view/synonym instead of TABLE_NAME in KALENDER schema.
 
Back
Top