查詢 table 的 schema 和 tablespace 的方法

2016-07-29 15:37

SQL> select OWNER, TABLE_NAME, TABLESPACE_NAME from dba_tables where table_name='BOOK';

OWNER                          TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------ ------------------------------
SYS                            BOOK                           BOOK_TS