Oracle PL/SQL/System Tables Views/dba object tables

Query dba_object_tables

   <source lang="sql">

SQL> SQL> set verify off SQL> set linesize 82 SQL> set pagesize 9999 SQL> set feedback on SQL> SQL> Prompt Object Tables Object Tables SQL> SQL> column tablespace_name format a16 heading "Tablespace Name" SQL> column table_name format a25 heading "Table Name" SQL> column type_name format a30 heading "Type Name" SQL> SQL> select tablespace_name, table_name,

 2         table_type_owner || "." || table_type type_name
 3    from dba_object_tables
 4   where owner = USER
 5   order by tablespace_name, table_name
 6  /

Tablespace Name Table Name Type Name

---

------------------------- ------------------------------

SYSTEM EMPS_NT sqle.EMP_TYPE 1 row selected. SQL> SQL> SQL> --

</source>