Select File Names Associated with Tables
As the DBA, you can select the names of the disk files associated with tables by using the iifile_info view, as shown in this example:
select table_name, owner_name, file_name, file_ext
from iifile_info;
Last modified date: 01/30/2023