Query to Find Out the File and Block IDs
SQL> SQL> SELECT SEGMENT_NAME, 2 FILE_ID, 3 BLOCK_ID 4 FROM DBA_EXTENTS 5 WHERE OWNER = 'OE' 6 AND SEGMENT_NAME LIKE 'ORDERS%' 7 / no rows selected SQL> SQL> --