此问题/答案应给予您所需的详细信息：Get list of all tables in Oracle?
但总的来说

-- If you have access
SELECT owner, table_name
  FROM dba_tables

-- Will show what your user has access to
SELECT owner, table_name
  FROM all_tables

SHOW TABLES  IN `db`;

其中db是数据库的名称。