Hello,
anyone knows, why the ALL_Objects View does not show database Links. I tried following Views:
SELECT * FROM USER_DB_LINKS; -- show Database Links
SELECT * FROM ALL_DB_LINKS WHERE Owner = 'SCHEMANAME'; -- show Database Links
SELECT * FROM USER_Objects WHERE Object_Type = 'DATABASE LINK'; -- show Database Links
SELECT * FROM ALL_Objects WHERE Owner = 'SCHEMANAME' AND Object_Type = 'DATABASE LINK'; -- dont show Database Links
SELECT * FROM DBA_Objects WHERE Owner = 'SCHEMANAME' AND Object_Type = 'DATABASE LINK'; -- show Database Links
sql_coder