tablespace에 속한 table 조회(owner)

Tablespace에 속한 Table을 조회 할 수 있다.

SQL> select table_name,tablespace_name
  2  from dba_tables
  3 where owner='SCOTT'
SQL> /

TABLE_NAME		       TABLESPACE_NAME
------------------------------ ------------------------------
DEPT			       USERS
EMP			       USERS
BONUS			       USERS
SALGRADE		       USERS
PROFESSOR		       USERS
DEPARTMENT		       USERS
STUDENT 		       USERS
EMP2			       USERS
DEPT2			       USERS
CAL			       USERS
GIFT			       USERS

TABLE_NAME		       TABLESPACE_NAME
------------------------------ ------------------------------
GOGAK			       USERS
HAKJUM			       USERS
EXAM_01 		       USERS
P_GRADE 		       USERS
REG_TEST		       USERS
P_01			       USERS
P_02			       USERS
PT_01			       USERS
PT_02			       USERS
P_TOTAL 		       USERS
TEST_NOVALIDATE 	       USERS

TABLE_NAME		       TABLESPACE_NAME
------------------------------ ------------------------------
TEST_VALIDATE		       USERS
TEST_ENABLE		       USERS
PRODUCT 		       USERS
PANMAE			       USERS
MEMBER			       USERS
REG_TEST2		       USERS
FRUIT			       USERS
DAECHUL 		       USERS
JUMSU			       USERS
TARAN			       SPIDER
H_TARAN 		       SPIDER

33 rows selected.

찾았다....taran테이블과 h_taran테이블..