List all tables from a schema of Oracle database

How to list all tables from a schema of Oracle database

To list all tables from a schema of Oracle database you can use tables: USER_TABLES, USER_ALL_TABLES, TABS, ALL_TABLES, DBA_TABLES, USER_OBJECTS.
Certain tables require privileges from the database DBA.
The most used tables are USER_TABLES and USER_OBJECTS.

Examples

  
SELECT * FROM USER_TABLES;

SELECT * FROM USER_TABLES 
WHERE TABLESPACE_NAME='SYSTEM';

SELECT * FROM USER_ALL_TABLES 
WHERE TABLESPACE_NAME='SYSTEM';

SELECT * FROM TABS 
WHERE TABLESPACE_NAME='SYSTEM';

SELECT * FROM ALL_TABLES 
WHERE TABLESPACE_NAME='SYSTEM';

SELECT * FROM DBA_TABLES 
WHERE TABLESPACE_NAME='SYSTEM';

SELECT * FROM USER_OBJECTS 
WHERE OBJECT_TYPE = 'TABLE';