Query dba_tables by owners : DBA_Tables « System Tables Views « Oracle PL / SQL






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

Query dba_tables by owners

  
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.








Related examples in the same category

1.Get owner, table name and table space name from dba_tables
2.Data Dictionary Scope
3.Query dba_tables for table info
4.select cluster_name, owner, table_name from dba_tables