|
SQL>
SQL>
SQL> select owner, table_name, tablespace_name
2 from dba_tables
3 where owner in (‘SCOTT‘, ’HR’) and rownum < 50
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>
|
Tags: Code, Data Dictionary Scope, DBATables laquo System Tables Views laquo Oracle PL SQL, DBA_Tables, Oracle PL / SQL, System Tables Views
Posted in Uncategorized |
This entry was posted
on Tuesday, August 4th, 2009 at 5:40 am and is filed under Uncategorized.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
