2013年1月24日
摘要: List tables and their corresponding tablespace name and data fileFollowing is a way to list a table name and its corresponding tablespace name and data file.SQL>select t.table_name,t.tablespace_name,df.file_name from dba_tables t, dba_data_files df2 where t.tablespace_name = df.tablespace_name;Fu 阅读全文
posted @ 2013-01-24 06:48 Simon Han 阅读(187) 评论(0) 推荐(0) 编辑