8. Maintaining Databases : How File Names Are Assigned for Tables : Select File Names Associated with Tables
 
Share this page                  
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;