Querying table names that belongs to another database

Question

I would like to query all the table names that belongs to another database. I can query the contents of a table in another database using oracle links for example: select * from owner.tablename@another_database; but how do I select the owner name and table names of the tables in another database? Thank you.

Answer 1

SELECT * FROM user_tables@another_database;