Get owner, table name and table space name from dba_tables : DBA_Tables « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. DBA_Tables

Get owner, table name and table space name from dba_tables

 

SQL>
SQL> select owner, table_name, tablespace_name
  2        from dba_tables
  3       where owner in ('SCOTT', 'HR')
  4       order by owner, tablespace_name, table_name;

OWNER                          TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------ ----------------
HR                             DEPARTMENTS                    USERS
HR                             EMPLOYEES                      USERS
HR                             JOBS                           USERS
HR                             JOB_HISTORY                    USERS
HR                             LOCATIONS                      USERS
HR                             REGIONS                        USERS
HR                             COUNTRIES

7 rows selected.

SQL>








Related examples in the same category

1.Data Dictionary Scope
2.Query dba_tables for table info
3.Query dba_tables by owners
4.select cluster_name, owner, table_name from dba_tables