SQL> create table t1 tablespace yy as select *from emp where 0=1;
表已创建。
SQL> analyze table t1 compute statistics;
表已分析。
> select table_name,num_rows,blocks,eMpty_blocks,avg_space from dba_tables where table_name='T1'
2 ;
TABLE_NAME NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE
------------------------------ ---------- ---------- ------------ ----------
T1 0 0 7 0
t1表是空表,t1表占用了8个block,有7个块是空的
SQL> select segment_name,extent_id,file_id,block_id,blocks from dba_extents where segment_name='T1';
SEGMENT_NAME EXTENT_ID FILE_ID BLOCK_ID BLOCKS
----------------------------------------------------------------- ---------- ---------- ---------- ----------
T1 0 6 9 8
block_id:Starting block number of the extent(一个区的起始block id)
SQL> select segment_name,header_file,header_block,blocks from dba_segments where segment_name='T1'
2 ;
SEGMENT_NAME HEADER_FILE HEADER_BLOCK (段头) BLOCKS
------------------------------------------------------------------ ----------- ------------ ----------
T1 6 9 (此块用来存放段头信息) 8
HEADER_BLOCK 段头就是初始区的第一个块,用来记录free list描述信息、extents信息,HWM信息等。
SQL> insert into t1 select *from emp;
已创建13行。
SQL> commit;
提交完成。
SQL> analyze table t1 compute statistics;
表已分析。
SQL> select table_name,num_rows,blocks,eMpty_blocks,avg_space from dba_tables where table_name='T1' ;
TABLE_NAME NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE
------------------------------ ---------- ---------- ------------ ----------
T1 13 1 6 7544
SQL> select segment_name,extent_id,file_id,block_id,blocks from dba_extents where segment_name='T1';
SEGMENT_NAME EXTENT_ID FILE_ID BLOCK_ID BLOCKS
-------------------------------------------------------------------------------- ---------- ---------- ---------- ----------
T1 0 6 9 8
SQL> insert into t1 select *from t1;
已创建117行。
SQL> commit;
提交完成。
SQL> analyze table t1 compute statistics;
SQL> select table_name,num_rows,blocks,eMpty_blocks,avg_space from dba_tables where table_name='T1' ;
TABLE_NAME NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE
------------------------------ ---------- ---------- ------------ ----------
T1 234 2 5 3272
SQL> select empno,
2 ename,
3 rowid,
4 dbms_rowid.rowid_object(rowid) object_id,
5 dbms_rowid.rowid_relative_fno(rowid) file_id,
6 dbms_rowid.rowid_block_number(rowid) block_id,
7 dbms_rowid.rowid_row_number(rowid) num
8 from scott.t1;
EMPNO ENAME ROWID OBJECT_ID FILE_ID BLOCK_ID NUM
----- ---------- ------------------ ---------- ---------- ---------- ----------
1 a AAAMWjAAGAAAAAKAAA 50595 6 10 0
7369 SMITH AAAMWjAAGAAAAAKAAB 50595 6 10 1
7499 ALLEN AAAMWjAAGAAAAAKAAC 50595 6 10 2
7521 WARD AAAMWjAAGAAAAAKAAD 50595 6 10 3
7566 JONES AAAMWjAAGAAAAAKAAE 50595 6 10 4
7654 MARTIN AAAMWjAAGAAAAAKAAF 50595 6 10 5
7698 BLAKE AAAMWjAAGAAAAAKAAG 50595 6 10 6
7782 CLARK AAAMWjAAGAAAAAKAAH 50595 6 10 7
7839 KING AAAMWjAAGAAAAAKAAI 50595 6 10 8
7844 TURNER AAAMWjAAGAAAAAKAAJ 50595 6 10 9
7900 JAMES AAAMWjAAGAAAAAKAAK 50595 6 10 10
7902 FORD AAAMWjAAGAAAAAKAAL 50595 6 10 11
7934 MILLER AAAMWjAAGAAAAAKAAM 50595 6 10 12
13 rows selected
数据的存放是从block id为10的block开始,不断增加
SQL> select empno,
2 ename,
3 rowid,
4 dbms_rowid.rowid_object(rowid) object_id,
5 dbms_rowid.rowid_relative_fno(rowid) file_id,
6 dbms_rowid.rowid_block_number(rowid) block_id,
7 dbms_rowid.rowid_row_number(rowid) num
8 from scott.t1
9 ;
EMPNO ENAME ROWID OBJECT_ID FILE_ID BLOCK_ID NUM
----- ---------- ------------------ ---------- ---------- ---------- ----------
1 a AAAMWjAAGAAAAAKAAA 50595 6 10 0
7369 SMITH AAAMWjAAGAAAAAKAAB 50595 6 10 1
7499 ALLEN AAAMWjAAGAAAAAKAAC 50595 6 10 2
7521 WARD AAAMWjAAGAAAAAKAAD 50595 6 10 3
7566 JONES AAAMWjAAGAAAAAKAAE 50595 6 10 4
7654 MARTIN AAAMWjAAGAAAAAKAAF 50595 6 10 5
7698 BLAKE AAAMWjAAGAAAAAKAAG 50595 6 10 6
7782 CLARK AAAMWjAAGAAAAAKAAH 50595 6 10 7
7839 KING AAAMWjAAGAAAAAKAAI 50595 6 10 8
7844 TURNER AAAMWjAAGAAAAAKAAJ 50595 6 10 9
7900 JAMES AAAMWjAAGAAAAAKAAK 50595 6 10 10
7902 FORD AAAMWjAAGAAAAAKAAL 50595 6 10 11
7934 MILLER AAAMWjAAGAAAAAKAAM 50595 6 10 12
1 a AAAMWjAAGAAAAAKAAN 50595 6 10 13
7369 SMITH AAAMWjAAGAAAAAKAAO 50595 6 10 14
7499 ALLEN AAAMWjAAGAAAAAKAAP 50595 6 10 15
7521 WARD AAAMWjAAGAAAAAKAAQ 50595 6 10 16
7566 JONES AAAMWjAAGAAAAAKAAR 50595 6 10 17
7654 MARTIN AAAMWjAAGAAAAAKAAS 50595 6 10 18
7698 BLAKE AAAMWjAAGAAAAAKAAT 50595 6 10 19
EMPNO ENAME ROWID OBJECT_ID FILE_ID BLOCK_ID NUM
----- ---------- ------------------ ---------- ---------- ---------- ----------
7782 CLARK AAAMWjAAGAAAAAKAAU 50595 6 10 20
7839 KING AAAMWjAAGAAAAAKAAV 50595 6 10 21
7844 TURNER AAAMWjAAGAAAAAKAAW 50595 6 10 22
7900 JAMES AAAMWjAAGAAAAAKAAX 50595 6 10 23
7902 FORD AAAMWjAAGAAAAAKAAY 50595 6 10 24
7934 MILLER AAAMWjAAGAAAAAKAAZ 50595 6 10 25
1 a AAAMWjAAGAAAAAKAAa 50595 6 10 26
7369 SMITH AAAMWjAAGAAAAAKAAb 50595 6 10 27
7499 ALLEN AAAMWjAAGAAAAAKAAc 50595 6 10 28
7521 WARD AAAMWjAAGAAAAAKAAd 50595 6 10 29
7566 JONES AAAMWjAAGAAAAAKAAe 50595 6 10 30
7654 MARTIN AAAMWjAAGAAAAAKAAf 50595 6 10 31
7698 BLAKE AAAMWjAAGAAAAAKAAg 50595 6 10 32
7782 CLARK AAAMWjAAGAAAAAKAAh 50595 6 10 33
7839 KING AAAMWjAAGAAAAAKAAi 50595 6 10 34
7844 TURNER AAAMWjAAGAAAAAKAAj 50595 6 10 35
7900 JAMES AAAMWjAAGAAAAAKAAk 50595 6 10 36
7902 FORD AAAMWjAAGAAAAAKAAl 50595 6 10 37
7934 MILLER AAAMWjAAGAAAAAKAAm 50595 6 10 38
1 a AAAMWjAAGAAAAAKAAn 50595 6 10 39
7369 SMITH AAAMWjAAGAAAAAKAAo 50595 6 10 40
EMPNO ENAME ROWID OBJECT_ID FILE_ID BLOCK_ID NUM
----- ---------- ------------------ ---------- ---------- ---------- ----------
7499 ALLEN AAAMWjAAGAAAAAKAAp 50595 6 10 41
7521 WARD AAAMWjAAGAAAAAKAAq 50595 6 10 42
7566 JONES AAAMWjAAGAAAAAKAAr 50595 6 10 43
7654 MARTIN AAAMWjAAGAAAAAKAAs 50595 6 10 44
7698 BLAKE AAAMWjAAGAAAAAKAAt 50595 6 10 45
7782 CLARK AAAMWjAAGAAAAAKAAu 50595 6 10 46
7839 KING AAAMWjAAGAAAAAKAAv 50595 6 10 47
7844 TURNER AAAMWjAAGAAAAAKAAw 50595 6 10 48
7900 JAMES AAAMWjAAGAAAAAKAAx 50595 6 10 49
7902 FORD AAAMWjAAGAAAAAKAAy 50595 6 10 50
7934 MILLER AAAMWjAAGAAAAAKAAz 50595 6 10 51
1 a AAAMWjAAGAAAAAKAA0 50595 6 10 52
7369 SMITH AAAMWjAAGAAAAAKAA1 50595 6 10 53
7499 ALLEN AAAMWjAAGAAAAAKAA2 50595 6 10 54
7521 WARD AAAMWjAAGAAAAAKAA3 50595 6 10 55
7566 JONES AAAMWjAAGAAAAAKAA4 50595 6 10 56
7654 MARTIN AAAMWjAAGAAAAAKAA5 50595 6 10 57
7698 BLAKE AAAMWjAAGAAAAAKAA6 50595 6 10 58
7782 CLARK AAAMWjAAGAAAAAKAA7 50595 6 10 59
7839 KING AAAMWjAAGAAAAAKAA8 50595 6 10 60
7844 TURNER AAAMWjAAGAAAAAKAA9 50595 6 10 61
EMPNO ENAME ROWID OBJECT_ID FILE_ID BLOCK_ID NUM
----- ---------- ------------------ ---------- ---------- ---------- ----------
7900 JAMES AAAMWjAAGAAAAAKAA+ 50595 6 10 62
7902 FORD AAAMWjAAGAAAAAKAA/ 50595 6 10 63
7934 MILLER AAAMWjAAGAAAAAKABA 50595 6 10 64
1 a AAAMWjAAGAAAAAKABB 50595 6 10 65
7369 SMITH AAAMWjAAGAAAAAKABC 50595 6 10 66
7499 ALLEN AAAMWjAAGAAAAAKABD 50595 6 10 67
7521 WARD AAAMWjAAGAAAAAKABE 50595 6 10 68
7566 JONES AAAMWjAAGAAAAAKABF 50595 6 10 69
7654 MARTIN AAAMWjAAGAAAAAKABG 50595 6 10 70
7698 BLAKE AAAMWjAAGAAAAAKABH 50595 6 10 71
7782 CLARK AAAMWjAAGAAAAAKABI 50595 6 10 72
7839 KING AAAMWjAAGAAAAAKABJ 50595 6 10 73
7844 TURNER AAAMWjAAGAAAAAKABK 50595 6 10 74
7900 JAMES AAAMWjAAGAAAAAKABL 50595 6 10 75
7902 FORD AAAMWjAAGAAAAAKABM 50595 6 10 76
7934 MILLER AAAMWjAAGAAAAAKABN 50595 6 10 77
1 a AAAMWjAAGAAAAAKABO 50595 6 10 78
7369 SMITH AAAMWjAAGAAAAAKABP 50595 6 10 79
7499 ALLEN AAAMWjAAGAAAAAKABQ 50595 6 10 80
7521 WARD AAAMWjAAGAAAAAKABR 50595 6 10 81
7566 JONES AAAMWjAAGAAAAAKABS 50595 6 10 82
EMPNO ENAME ROWID OBJECT_ID FILE_ID BLOCK_ID NUM
----- ---------- ------------------ ---------- ---------- ---------- ----------
7654 MARTIN AAAMWjAAGAAAAAKABT 50595 6 10 83
7698 BLAKE AAAMWjAAGAAAAAKABU 50595 6 10 84
7782 CLARK AAAMWjAAGAAAAAKABV 50595 6 10 85
7839 KING AAAMWjAAGAAAAAKABW 50595 6 10 86
7844 TURNER AAAMWjAAGAAAAAKABX 50595 6 10 87
7900 JAMES AAAMWjAAGAAAAAKABY 50595 6 10 88
7902 FORD AAAMWjAAGAAAAAKABZ 50595 6 10 89
7934 MILLER AAAMWjAAGAAAAAKABa 50595 6 10 90
1 a AAAMWjAAGAAAAAKABb 50595 6 10 91
7369 SMITH AAAMWjAAGAAAAAKABc 50595 6 10 92
7499 ALLEN AAAMWjAAGAAAAAKABd 50595 6 10 93
7521 WARD AAAMWjAAGAAAAAKABe 50595 6 10 94
7566 JONES AAAMWjAAGAAAAAKABf 50595 6 10 95
7654 MARTIN AAAMWjAAGAAAAAKABg 50595 6 10 96
7698 BLAKE AAAMWjAAGAAAAAKABh 50595 6 10 97
7782 CLARK AAAMWjAAGAAAAAKABi 50595 6 10 98
7839 KING AAAMWjAAGAAAAAKABj 50595 6 10 99
7844 TURNER AAAMWjAAGAAAAAKABk 50595 6 10 100
7900 JAMES AAAMWjAAGAAAAAKABl 50595 6 10 101
7902 FORD AAAMWjAAGAAAAAKABm 50595 6 10 102
7934 MILLER AAAMWjAAGAAAAAKABn 50595 6 10 103
EMPNO ENAME ROWID OBJECT_ID FILE_ID BLOCK_ID NUM
----- ---------- ------------------ ---------- ---------- ---------- ----------
1 a AAAMWjAAGAAAAAKABo 50595 6 10 104
7369 SMITH AAAMWjAAGAAAAAKABp 50595 6 10 105
7499 ALLEN AAAMWjAAGAAAAAKABq 50595 6 10 106
7521 WARD AAAMWjAAGAAAAAKABr 50595 6 10 107
7566 JONES AAAMWjAAGAAAAAKABs 50595 6 10 108
7654 MARTIN AAAMWjAAGAAAAAKABt 50595 6 10 109
7698 BLAKE AAAMWjAAGAAAAAKABu 50595 6 10 110
7782 CLARK AAAMWjAAGAAAAAKABv 50595 6 10 111
7839 KING AAAMWjAAGAAAAAKABw 50595 6 10 112
7844 TURNER AAAMWjAAGAAAAAKABx 50595 6 10 113
7900 JAMES AAAMWjAAGAAAAAKABy 50595 6 10 114
7902 FORD AAAMWjAAGAAAAAKABz 50595 6 10 115
7934 MILLER AAAMWjAAGAAAAAKAB0 50595 6 10 116
1 a AAAMWjAAGAAAAAKAB1 50595 6 10 117
7369 SMITH AAAMWjAAGAAAAAKAB2 50595 6 10 118
7499 ALLEN AAAMWjAAGAAAAAKAB3 50595 6 10 119
7521 WARD AAAMWjAAGAAAAAKAB4 50595 6 10 120
7566 JONES AAAMWjAAGAAAAAKAB5 50595 6 10 121
7654 MARTIN AAAMWjAAGAAAAAKAB6 50595 6 10 122
7698 BLAKE AAAMWjAAGAAAAAKAB7 50595 6 10 123
7782 CLARK AAAMWjAAGAAAAAKAB8 50595 6 10 124
EMPNO ENAME ROWID OBJECT_ID FILE_ID BLOCK_ID NUM
----- ---------- ------------------ ---------- ---------- ---------- ----------
7839 KING AAAMWjAAGAAAAAKAB9 50595 6 10 125
7844 TURNER AAAMWjAAGAAAAAKAB+ 50595 6 10 126
7900 JAMES AAAMWjAAGAAAAAKAB/ 50595 6 10 127
7902 FORD AAAMWjAAGAAAAAKACA 50595 6 10 128
7934 MILLER AAAMWjAAGAAAAAKACB 50595 6 10 129
1 a AAAMWjAAGAAAAAKACC 50595 6 10 130
7369 SMITH AAAMWjAAGAAAAAKACD 50595 6 10 131
7499 ALLEN AAAMWjAAGAAAAAKACE 50595 6 10 132
7521 WARD AAAMWjAAGAAAAAKACF 50595 6 10 133
7566 JONES AAAMWjAAGAAAAAKACG 50595 6 10 134
7654 MARTIN AAAMWjAAGAAAAAKACH 50595 6 10 135
7698 BLAKE AAAMWjAAGAAAAAKACI 50595 6 10 136
7782 CLARK AAAMWjAAGAAAAAKACJ 50595 6 10 137
7839 KING AAAMWjAAGAAAAAKACK 50595 6 10 138
7844 TURNER AAAMWjAAGAAAAAKACL 50595 6 10 139
7900 JAMES AAAMWjAAGAAAAAKACM 50595 6 10 140
7902 FORD AAAMWjAAGAAAAAKACN 50595 6 10 141
7934 MILLER AAAMWjAAGAAAAAKACO 50595 6 10 142
1 a AAAMWjAAGAAAAAKACP 50595 6 10 143
7369 SMITH AAAMWjAAGAAAAAKACQ 50595 6 10 144
7499 ALLEN AAAMWjAAGAAAAAKACR 50595 6 10 145
EMPNO ENAME ROWID OBJECT_ID FILE_ID BLOCK_ID NUM
----- ---------- ------------------ ---------- ---------- ---------- ----------
7521 WARD AAAMWjAAGAAAAAKACS 50595 6 10 146
7566 JONES AAAMWjAAGAAAAAKACT 50595 6 10 147
7654 MARTIN AAAMWjAAGAAAAAKACU 50595 6 10 148
7698 BLAKE AAAMWjAAGAAAAAKACV 50595 6 10 149
7782 CLARK AAAMWjAAGAAAAAKACW 50595 6 10 150
7839 KING AAAMWjAAGAAAAAKACX 50595 6 10 151
7844 TURNER AAAMWjAAGAAAAAKACY 50595 6 10 152
7900 JAMES AAAMWjAAGAAAAAKACZ 50595 6 10 153
7902 FORD AAAMWjAAGAAAAAKACa 50595 6 10 154
7934 MILLER AAAMWjAAGAAAAAKACb 50595 6 10 155
1 a AAAMWjAAGAAAAAKACc 50595 6 10 156
7369 SMITH AAAMWjAAGAAAAAKACd 50595 6 10 157
7499 ALLEN AAAMWjAAGAAAAAKACe 50595 6 10 158
7521 WARD AAAMWjAAGAAAAAKACf 50595 6 10 159
7566 JONES AAAMWjAAGAAAAAKACg 50595 6 10 160
7654 MARTIN AAAMWjAAGAAAAAKACh 50595 6 10 161
7698 BLAKE AAAMWjAAGAAAAAKACi 50595 6 10 162
7782 CLARK AAAMWjAAGAAAAAKACj 50595 6 10 163
7839 KING AAAMWjAAGAAAAAKACk 50595 6 10 164
7844 TURNER AAAMWjAAGAAAAAKACl 50595 6 10 165
7900 JAMES AAAMWjAAGAAAAAKACm 50595 6 10 166
EMPNO ENAME ROWID OBJECT_ID FILE_ID BLOCK_ID NUM
----- ---------- ------------------ ---------- ---------- ---------- ----------
7902 FORD AAAMWjAAGAAAAAKACn 50595 6 10 167
7934 MILLER AAAMWjAAGAAAAAKACo 50595 6 10 168
1 a AAAMWjAAGAAAAAKACp 50595 6 10 169
7369 SMITH AAAMWjAAGAAAAAKACq 50595 6 10 170
7499 ALLEN AAAMWjAAGAAAAAKACr 50595 6 10 171
7521 WARD AAAMWjAAGAAAAAKACs 50595 6 10 172
7566 JONES AAAMWjAAGAAAAAKACt 50595 6 10 173
7654 MARTIN AAAMWjAAGAAAAAKACu 50595 6 10 174
7698 BLAKE AAAMWjAAGAAAAAKACv 50595 6 10 175
7782 CLARK AAAMWjAAGAAAAALAAA 50595 6 11 0
7839 KING AAAMWjAAGAAAAALAAB 50595 6 11 1
7844 TURNER AAAMWjAAGAAAAALAAC 50595 6 11 2
7900 JAMES AAAMWjAAGAAAAALAAD 50595 6 11 3
7902 FORD AAAMWjAAGAAAAALAAE 50595 6 11 4
7934 MILLER AAAMWjAAGAAAAALAAF 50595 6 11 5
1 a AAAMWjAAGAAAAALAAG 50595 6 11 6
7369 SMITH AAAMWjAAGAAAAALAAH 50595 6 11 7
7499 ALLEN AAAMWjAAGAAAAALAAI 50595 6 11 8
7521 WARD AAAMWjAAGAAAAALAAJ 50595 6 11 9
7566 JONES AAAMWjAAGAAAAALAAK 50595 6 11 10
7654 MARTIN AAAMWjAAGAAAAALAAL 50595 6 11 11
EMPNO ENAME ROWID OBJECT_ID FILE_ID BLOCK_ID NUM
----- ---------- ------------------ ---------- ---------- ---------- ----------
7698 BLAKE AAAMWjAAGAAAAALAAM 50595 6 11 12
7782 CLARK AAAMWjAAGAAAAALAAN 50595 6 11 13
7839 KING AAAMWjAAGAAAAALAAO 50595 6 11 14
7844 TURNER AAAMWjAAGAAAAALAAP 50595 6 11 15
7900 JAMES AAAMWjAAGAAAAALAAQ 50595 6 11 16
7902 FORD AAAMWjAAGAAAAALAAR 50595 6 11 17
7934 MILLER AAAMWjAAGAAAAALAAS 50595 6 11 18
1 a AAAMWjAAGAAAAALAAT 50595 6 11 19
7369 SMITH AAAMWjAAGAAAAALAAU 50595 6 11 20
7499 ALLEN AAAMWjAAGAAAAALAAV 50595 6 11 21
7521 WARD AAAMWjAAGAAAAALAAW 50595 6 11 22
7566 JONES AAAMWjAAGAAAAALAAX 50595 6 11 23
7654 MARTIN AAAMWjAAGAAAAALAAY 50595 6 11 24
7698 BLAKE AAAMWjAAGAAAAALAAZ 50595 6 11 25
7782 CLARK AAAMWjAAGAAAAALAAa 50595 6 11 26
7839 KING AAAMWjAAGAAAAALAAb 50595 6 11 27
7844 TURNER AAAMWjAAGAAAAALAAc 50595 6 11 28
7900 JAMES AAAMWjAAGAAAAALAAd 50595 6 11 29
7902 FORD AAAMWjAAGAAAAALAAe 50595 6 11 30
7934 MILLER AAAMWjAAGAAAAALAAf 50595 6 11 31
1 a AAAMWjAAGAAAAALAAg 50595 6 11 32
EMPNO ENAME ROWID OBJECT_ID FILE_ID BLOCK_ID NUM
----- ---------- ------------------ ---------- ---------- ---------- ----------
7369 SMITH AAAMWjAAGAAAAALAAh 50595 6 11 33
7499 ALLEN AAAMWjAAGAAAAALAAi 50595 6 11 34
7521 WARD AAAMWjAAGAAAAALAAj 50595 6 11 35
7566 JONES AAAMWjAAGAAAAALAAk 50595 6 11 36
7654 MARTIN AAAMWjAAGAAAAALAAl 50595 6 11 37
7698 BLAKE AAAMWjAAGAAAAALAAm 50595 6 11 38
7782 CLARK AAAMWjAAGAAAAALAAn 50595 6 11 39
7839 KING AAAMWjAAGAAAAALAAo 50595 6 11 40
7844 TURNER AAAMWjAAGAAAAALAAp 50595 6 11 41
7900 JAMES AAAMWjAAGAAAAALAAq 50595 6 11 42
7902 FORD AAAMWjAAGAAAAALAAr 50595 6 11 43
7934 MILLER AAAMWjAAGAAAAALAAs 50595 6 11 44
1 a AAAMWjAAGAAAAALAAt 50595 6 11 45
7369 SMITH AAAMWjAAGAAAAALAAu 50595 6 11 46
7499 ALLEN AAAMWjAAGAAAAALAAv 50595 6 11 47
7521 WARD AAAMWjAAGAAAAALAAw 50595 6 11 48
7566 JONES AAAMWjAAGAAAAALAAx 50595 6 11 49
7654 MARTIN AAAMWjAAGAAAAALAAy 50595 6 11 50
7698 BLAKE AAAMWjAAGAAAAALAAz 50595 6 11 51
7782 CLARK AAAMWjAAGAAAAALAA0 50595 6 11 52
7839 KING AAAMWjAAGAAAAALAA1 50595 6 11 53
EMPNO ENAME ROWID OBJECT_ID FILE_ID BLOCK_ID NUM
----- ---------- ------------------ ---------- ---------- ---------- ----------
7844 TURNER AAAMWjAAGAAAAALAA2 50595 6 11 54
7900 JAMES AAAMWjAAGAAAAALAA3 50595 6 11 55
7902 FORD AAAMWjAAGAAAAALAA4 50595 6 11 56
7934 MILLER AAAMWjAAGAAAAALAA5 50595 6 11 57
234 rows selected