oracle怎么查询表对应的表空间

Question

如题所述

Answer 1

1、select TABLE_NAME,DEF_TABLESPACE_NAME from USER_PART_TABLES order by DEF_TABLESPACE_NAME;
2、col SEGMENT_NAME format a30
select distinct SEGMENT_NAME,TABLESPACE_NAME from dba_segments where TABLESPACE_NAME=‘TS1’ order by SEGMENT_NAME;
3、 select TABLE_NAME,TABLESPACE_NAME from user_tables order by table_name;