IN ORACLE MILIEU …

we can get the information about which table is present in which datafile. For that you can seach for file_id in dba_extents using the segment name as your table name. using this file ID we can get the tablespace_name and file_name from dba_data_filesExample: select file_id, block_id, segment_name from dba_extents where segment_name = ‘IGI_MPP_AP_INVOICES_I1′ FILE_ID BLOCK_ID [...]