Dear all,
I have a question about USER_TABLES table and database links. I have a database link to a remote schema that allows me to access its tables without needing to change the connection.
My problem is that when I try to run:
SQL> SELECT table_name
FROM user_tables@dbLinkToRemotSchema
no rows selected.
As I understand (please correct me if I'm wrong), because I'm using a database link to connect to the remote schema, I'm not considered to be the owner of those tables and therefore the query doesn't return any row.
However I need to have access in a PL/SQL script to both my own user_tables and also that of the remote schema. Is there any way to achieve this?
Thanks in advance,
Kind Regards,
Dariyoosh