radcoders
asked on
See all tables within an oracle dblink
I need to see all the tables within a dblink'd schema in oracle. What is the query to see all tables?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to help.
I suppose I should also point out that there is a USER level view that will show you the tables owned by the user used in the dblink.
ALL level views show everyhing this user can access.
User level:
select table_name from user_tables@dblinkname;
I suppose I should also point out that there is a USER level view that will show you the tables owned by the user used in the dblink.
ALL level views show everyhing this user can access.
User level:
select table_name from user_tables@dblinkname;
ASKER