SQL> select count(distinct table_name) 2 from dba_tab_columns 3 where data_type_owner is not null; COUNT(DISTINCTTABLE_NAME) ------------------------- 498