Query dba_object_tables
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 JAVA2S.EMP_TYPE
1 row selected.
SQL>
SQL>
SQL> --
Related examples in the same category