1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

Tips

Datafile Table Relation

Monday, 18 June 2018 11:14

Which datafile contains my table in Oracle? How do I find it out

You can use the below query to find out the datafile in which a particular table is stored, this is an interesting topic when you get into issues like block corruption.

SQL> select a.segment_name, a.tablespace_name, b.file_name from dba_extents a, dba_data_files b where a.file_id = b.file_id and a.segment_name='VBAK';

{fcomment} {flike}

Share

Datafile Table Relation

Tips and Tricks