Table Information

To obtain the names of all of your tables, you can use the USER_TABLES.

DESCRIBE user_tables;

Name	Null?	Type
TABLE_NAME	NOT NULL	VARCHAR2(30)
TABLESPACE_NAME		VARCHAR2(30)
CLUSTER_NAME		VARCHAR2(30)
IOT_NAME		VARCHAR2(30)
STATUS		VARCHAR2(8)
PCT_FREE		NUMBER
PCT_USED		NUMBER

SELECT table_name FROM user_tables;

TABLE_NAME
DEPT
EMPLOYEES2
REGIONS
LOCATIONS
DEPARTMENTS
JOBS
EMPLOYEES
JOB_HISTORY
JOB_GRADES
COUNTRIES

In addition to providing the table name, it contains detailed information on the storage.

- The TABS view is a synonym of the USER_TABLES view.

- Also try, ALL_TABLES