Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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> --