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.

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';