一、创建表
SQL> create tablespace test datafile '/u01/app/oracle/oradata/test/test01.dbf' size 100m;
Tablespace created.
SQL> create user test identified by test default tablespace test;
User created.

SQL> grant connect,resource to test;
Grant succeeded.
SQL> conn test/test
Connected.
SQL> create table a01(id int ,name varchar2(10));
Table created.
SQL> insert into a01 VALUES(1,'AAAAA');
1 row created.
SQL> insert into a01 values(2,'AAAAA');
1 row created.
SQL> commit;
Commit complete.
SQL>
SQL> select rowid,id,name from a01;
ROWID ID NAME
------------------ ---------- ----------
AAAMiXAAFAAAAAMAAA 1 AAAAA
AAAMiXAAFAAAAAMAAB 2 AAAAA
SQL> select dbms_rowid.rowid_relative_fno(rowid) fno,dbms_rowid.rowid_block_number(rowid) bno,id,name from a01;

FNO BNO ID NAME
---------- ---------- ---------- ----------
5 12 1 AAAAA
5 12 2 AAAAA
BBED> set filename '/u01/app/oracle/oradata/test/test01.dbf'
FILENAME /u01/app/oracle/oradata/test/test01.dbf

BBED> set file 5
FILE# 5
BBED> set block 12
BLOCK# 12
BBED> show
FILE# 5
BLOCK# 12
OFFSET 0
DBA 0x0140000c (20971532 5,12)
FILENAME /u01/app/oracle/oradata/test/test01.dbf
BIFILE bifile.bbd
LISTFILE /u01/tmp/filelist.txt
BLOCKSIZE 8192
MODE Browse
EDIT Unrecoverable
IBASE Dec
OBASE Dec
WIDTH 80
COUNT 512
LOGFILE log.bbd
SPOOL No
5号文件第12个块

查看整个数据块
BBED> dump count 8192
File: /u01/app/oracle/oradata/test/test01.dbf (5)
Block: 12 Offsets: 0 to 8191 Dba:0x0140000c
------------------------------------------------------------------------
06a20000 0c004001 7cfb0600 00000406 36ab0000 01000000 97c80000 44fb0600
00000000 02003200 09004001 03000300 fb000000 38018000 cd004400 02200000
7cfb0600 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00010200 ffff1600 801f6a1f 6a1f0000 02008c1f 801f0000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
...........
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 2c010202 c1030541 41414141 2c010202 c1020541 41414141 04067cfb
Offsets: 0 to 8191 1024 * 8 = 8192个字节,正好8K。

ITPub博客

bbed实验测试

最新文章