SQL> variable file# number
SQL> execute :file#:=dbms_utility.data_block_address_file(to_number('400179','xxxxxxx'));
PL/SQL procedure successfully completed.
SQL> variable block# number
SQL> execute :block#:=dbms_utility.data_block_address_block(to_number('400179','xxxxxxx'));
PL/SQL procedure successfully completed.
SQL> print file#
FILE#
----------
1
SQL> print block#
BLOCK#
----------
377
SQL> SQL> col segment_name for a30
SQL> col segment_type for a30
SQL> select segment_name,segment_type from dba_segments where header_file=1 and header_block=377;
SEGMENT_NAME SEGMENT_TYPE
------------------------------ ------------------------------
BOOTSTRAP$ TABLE
SQL> select b.object_id,a.segment_name,a.segment_type,a.header_block from dba_segments a,dba_objects b
2 where a.segment_name = b.object_name(+) and a.header_file=1 and a.header_block<=377
3 order by a.header_block;
OBJECT_ID SEGMENT_NAME SEGMENT_TYPE HEADER_BLOCK
--------- ------------------------------ ------------------------------ ------------
SYSTEM ROLLBACK 9
2 C_OBJ# CLUSTER 25
3 I_OBJ# INDEX 49
6 C_TS# CLUSTER 57
7 I_TS# INDEX 65
8 C_FILE#_BLOCK# CLUSTER 73
9 I_FILE#_BLOCK# INDEX 81
10 C_USER# CLUSTER 89
11 I_USER# INDEX 97
15 UNDO$ TABLE 105
17 FILE$ TABLE 113
18 OBJ$ TABLE 121
23 PROXY_DATA$ TABLE 129
24 I_PROXY_DATA$ INDEX 137
25 PROXY_ROLE_DATA$ TABLE 145
26 I_PROXY_ROLE_DATA$_1 INDEX 153
27 I_PROXY_ROLE_DATA$_2 INDEX 161
28 CON$ TABLE 169
29 C_COBJ# CLUSTER 177
30 I_COBJ# INDEX 185
33 I_TAB1 INDEX 193
34 I_UNDO1 INDEX 201
35 I_UNDO2 INDEX 209
36 I_OBJ1 INDEX 217
37 I_OBJ2 INDEX 225
38 I_OBJ3 INDEX 233
39 I_IND1 INDEX 241
40 I_ICOL1 INDEX 249
41 I_FILE1 INDEX 257
42 I_FILE2 INDEX 265
43 I_TS1 INDEX 273
44 I_USER1 INDEX 281
45 I_COL1 INDEX 289
46 I_COL2 INDEX 297
47 I_COL3 INDEX 305
48 I_CON1 INDEX 313
49 I_CON2 INDEX 321
50 I_CDEF1 INDEX 329
51 I_CDEF2 INDEX 337
52 I_CDEF3 INDEX 345
53 I_CDEF4 INDEX 353
54 I_CCOL1 INDEX 361
55 I_CCOL2 INDEX 369
56 BOOTSTRAP$ TABLE 377
44 rows selected.
SQL> SQL>
