All_tables in Oracle Database - Oracleknohow

25K views Apr 20, 2023

What is ALL_TABLES? This data dictionary view provides information about the tables that are accessible to the current user. It includes information on tables owned by the user and tables for which the user has been granted access. Some columns of interest in this view include: OWNER: The schema that owns the table. TABLE_NAME: The name of the table. TABLESPACE_NAME: The tablespace in which the table resides. STATUS: Indicates if the table is valid or not. NUM_ROWS: The estimated number of rows in the table. LAST_ANALYZED: The timestamp of the last time the table was analyzed