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.
How to find the datafile which contains a particular table?
Updated May 18, 2018
Recommended Posts:
- What is Oracle?
- Oracle Training Tutorials for Beginners
- Difference Between Oracle 11g and 12c and 10g
- Import 12c Oracle Dump to 11g
- Ora 28001 The Password Has Expired Error
- Cache and Nocache in Oracle Sequence
- BR*Tools Documentation
- ORA-01455: Converting Column Overflows Integer Datatype
- Oracle Wait Events Interview Questions
- Difference Between Primary, Secondary and Clustered Indexes in DBMS
- Difference Between Hot and Cold Backup
- Oracle Partitioning Interview Questions
- Update Statement Works in Oracle Architecture
- Differences Between SAP HANA and Oracle
- Group Functions Ignore Null Values in Processed Column
- ORA-10458: Standby Database Requires Recovery
- Oracle Interview Questions
×