This post shows you how to shows all tables with Oracle linked server in SQL Server Management Studio.

You can use the sql query below.

SELECT *

FROM OPENQUERY(ORCL_LINK, 'SELECT  table_name, owner FROM  all_tables ORDER BY  owner, table_name')