查看表所属的表空间

5dm

SQL> select table_name,tablespace_name from user_tables;

TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
ICOL$                          SYSTEM
IND$                           SYSTEM
COL$                           SYSTEM
CLU$                           SYSTEM
TAB$                           SYSTEM
LOB$                           SYSTEM
COLTYPE$                       SYSTEM