Get list of all tables in ORACLE

A)
If user has access to all the tables, i.e. DBA grant provided, run the following query:

SELECT OWNER, TABLE_NAME
FROM dba_tables

B)
If you do not have access to DBA_TABLES, then you can run the following query to see the tables for which you have the access:

SELECT OWNER, TABLE_NAME
FROM ALL_TABLES

C)
If you are only concerned about tables that you own, then run the following:

SELECT OWNER, TABLE_NAME
FROM USER_TABLES

or

SELECT TABLE_NAME FROM ALL_TABLES

D)
If you are using SQL PLUS, we need to set the view to make sure the outcome is readable.

set colsep '|'
set linesize 150
set pagesize 50
set pagesize 1000

Now run the following queries:

D.1) To show all tables names

SELECT table_name, owner, tablespace_name FROM all_tables;

D.2) Show all tables owned by user

SELECT table_name FROM user_tables;