摘要:
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 阅读全文