Oracle/Administoration
tablespace에 속한 table 조회(owner)
새똥 마이쪙
2015. 1. 15. 11:38
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테이블..