Oracle: Listing All Tables from Database Link

To list all of the tables available over a database link:

select owner, table_name from all_tables@LinkName order by table_name;

Leave a Reply

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.