How to find the datafile which contains a particular table?
If you query DBA_EXTENTS based on segment_name equal to your table name you will see that the column FILE_ID will show you the database file where each extent is located. You can then use FILE_ID to query DBA_DATA_FILES to find the name of the datafile. Or you could do it all in one query using a join.
Related Questions
- The table in the map booklet says that there may be delays on some lines and then gives other figures for particular stations. How do I use these numbers?
- Im looking for photos of a table in a particular finish but cant seem to find them, any idea why?
- Is there a table that identifies all documents for a particular vendor code/suffix?
