system table for all Table objects

dbadmin=> select distinct table_type from all_tables;
    table_type
------------------
 GLOBAL TEMPORARY
 SYSTEM TABLE
 TABLE
 VIEW
(4 rows)

To see all user tables 

Select * from all_tables where table_type ='TABLE';

OR 

Select * from tables ;




select * from tables where table_name ='subscription' ;


 table_schema_id  | table_schema |     table_id      |  table_name  |     owner_id      | owner_name | is_temp_table | is_system_table | is_flextable | has_aggregate_projection | system_table_creator | partition_expression |          create_time          | table_definition
-------------------+--------------+-------------------+--------------+-------------------+------------+---------------+-----------------+--------------+--------------------------+----------------------+----------------------+-------------------------------+------------------

 45035996288655386 | CDW          | 49539595907101408 | subscription | 45035996273704962 | dbadmin    | f             | f               | f            | f                        |                      |                      | 2016-06-21 14:41:15.681759-07 |