oracle学习笔记之数据字典

select tablespace_name from dba_tablespaces;
//结果
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS

 

select table_name , tablespace_name , owner  from dba_tables where owner = '
SCOTT' ;
//结果
TABLE_NAME                     TABLESPACE OWNER
------------------------------ ---------- ------------------------------
DEPT                           USERS       SCOTT
EMP                            USERS       SCOTT
BONUS                        USERS       SCOTT
SALGRADE                   USERS       SCOTT