0018002 c1060180 01800180 ff02c102 03c21533 03c22964 018002c1 0203c202
<32 bytes per line>
BBED> dump file 7 block 10 count 8200
File: /u01/oracle/oradata/gname/mssm.dbf (7)
Block: 10 Offsets: 0 to 8191 Dba:0x01c0000a
------------------------------------------------------------------------
06a20000 0a00c001 a6ba0700 00000706 75f20000 01000000 17cd0000 96ba0700
00000000 02000300 00000000 02002500 0d010000 e8008000 3b010300 03200000
a6ba0700 00000000 00000000 00000000 00000000 00000000 00000000 00010300
ffff1800 831f691f 691f0000 0300981f 901f831f 00001300 09001c00 25004100
4b00891f 721f5b1f 441f2d1f 161fff1e e81ed11e ba1e2b1e 9c1d121d 871cfd1b
...
0f000040 6a8c0006 00406a8c 000603c2 5c22ac00 010f000f 0000406a 8c000500
406a8c00 0503c25c 1eac0001 0d000d00 00406a8c 00040040 6a8c0004 03c25c1c
ac00010d 000d0000 406a8c00 0300406a 8c000303 c25c18ac 00010800 08000040
6a8c0002 00406a8c 000203c2 5c16ac00 010c000c 0000406a 8c000100 406a8c2c
010203c2 0a640573 6576656e 2c010202 c1030162 2c010202 c1020161 0706a6ba
<32 bytes per line>
SQL> select dump(id,16) from t;
DUMP(ID,16)
--------------------------------------------------------------------------------
Typ=2 Len=2: c1,2
Typ=2 Len=2: c1,3
Typ=2 Len=3: c2,a,64
SQL> select dump(name,16) from t;
DUMP(NAME,16)
--------------------------------------------------------------------------------
Typ=1 Len=1: 61
Typ=1 Len=1: 62
Typ=1 Len=5: 73,65,76,65,6e
SQL> @getrowidinfo
Enter value for owner: ms1
Enter value for table: t
ID NAME ROWID_TYPE FILE_NO BLOCK_NO ROW_NO ORA_ROWSCN OBJECT_NO
---------- -------------------- ---------- ---------- ---------- ---------- ---------- ----------
1 a 1 7 10 0 506534 52503
2 b 1 7 10 1 506534 52503
999 seven 1 7 10 2 506534 52503
BBED> set file 7 block 10 offset 0
FILE# 7
BLOCK# 10
OFFSET 0
BBED> find /c a top
File: /u01/oracle/oradata/gname/mssm.dbf (7)
Block: 10 Offsets: 8187 to 8191 Dba:0x01c0000a
------------------------------------------------------------------------
610706a6 ba
<32 bytes per line>
BBED> d /v dba 7,10 offset 8187
File: /u01/oracle/oradata/gname/mssm.dbf (7)
Block: 10 Offsets: 8187 to 8191 Dba:0x01c0000a
-------------------------------------------------------
610706a6 ba l a....
<16 bytes per line>
BBED> set file 7 block 10 offset 2
FILE# 7
BLOCK# 10
OFFSET 2
BBED> find /c s top
File: /u01/oracle/oradata/gname/mssm.dbf (7)
Block: 10 Offsets: 8167 to 8191 Dba:0x01c0000a
------------------------------------------------------------------------
73657665 6e2c0102 02c10301 622c0102 02c10201 610706a6 ba
<32 bytes per line>
BBED> d /v dba 7,10 offset 8167
File: /u01/oracle/oradata/gname/mssm.dbf (7)
Block: 10 Offsets: 8167 to 8191 Dba:0x01c0000a
-------------------------------------------------------
73657665 6e2c0102 02c10301 622c0102 l seven,......b,..
02c10201 610706a6 ba l ....a....
<16 bytes per line>
SQL> update t set name='sven' where id=999;
1 row updated.
SQL> commit;
Commit complete.
SQL> alter system checkpoint;
System altered.
SQL>
SQL> @getrowidinfo
Enter value for owner: ms1
Enter value for table: t
ID NAME ROWID_TYPE FILE_NO BLOCK_NO ROW_NO ORA_ROWSCN OBJECT_NO
---------- -------------------- ---------- ---------- ---------- ---------- ---------- ----------
1 a 1 7 10 0 513384 52503
2 b 1 7 10 1 513384 52503
999 sven 1 7 10 2 513384 52503
BBED> set file 7 block 10 offset 2
FILE# 7
BLOCK# 10
OFFSET 2
BBED> find /c s top --查找字符串s
File: /u01/oracle/ora |