[20121120]windows下使用bbed.txt

学习需要，需要在windows下使用bbed，但是我发现在windows下如何编译bbed呢？我google发现如下链接：

http://www.xifenfei.com/3876.html

发现我公司的9.2.0.8的windows版本有bbed.exe，按照介绍我copy这些相关文件到我的机器:

 驱动器 D 中的卷是 DATA
 卷的序列号是 38FB-540B

 D:\tools\bbed 的目录

2012-11-20  08:39              .
2012-11-20  08:39              ..
2006-07-29  13:33           147,728 bbed.exe
2006-06-28  11:32            20,752 heteroxa9.dll
2005-03-04  05:06            49,152 kpp95rdr.dll
2005-03-04  05:06            45,056 kpp97rdr.dll
2012-11-20  08:40             1,877 log.bbd
2006-07-29  02:08           229,648 njssl9.dll
2006-06-28  11:33            61,712 ocijdbc9.dll
2002-04-26  16:22           733,184 oip9.dll
2006-07-29  14:02         1,589,520 oraclient9.dll
2006-07-29  15:25           602,384 oracommon9.dll
2006-06-28  09:54           651,536 ORACORE9.DLL
2006-06-27  08:44         1,736,976 oractxx9.dll
2006-07-29  14:02         2,691,344 orageneric9.dll
2006-07-29  13:56            24,576 oraimr9.dll
2006-07-29  15:19         3,014,656 orajox9.dll
2006-06-28  03:09           155,920 oraldapclnt9.dll
2006-06-28  03:09            24,848 oraldapjclnt9.dll
2006-07-29  02:18           741,648 oran9.dll
2006-07-29  02:10            41,232 oranad9.dll
2006-07-29  02:06            33,040 oranbeq9.dll
2006-07-29  02:08            24,848 ORANCDS9.DLL
2006-07-29  02:07            98,576 orancrypt9.dll
2006-07-29  02:07            33,040 ORANGSS9.DLL
2006-07-29  02:07            24,848 oranhost9.dll
2006-07-29  02:06            33,040 oranipc9.dll
2006-07-29  02:08           176,400 oranjni9.dll
2006-07-29  02:07           213,264 ORANK59.DLL
2006-07-29  02:06           180,496 oranl9.dll
2006-07-29  02:07            74,000 oranldap9.dll
2006-07-29  02:08            28,944 oranldapj9.dll
2006-06-28  06:32           499,984 ORANLS9.DLL
2006-06-27  05:29            28,944 oranms.dll
2006-06-27  05:29            69,904 oranmsp.dll
2006-07-29  02:06            33,040 orannmp9.dll
2006-07-29  02:07            53,520 orannts9.dll
2006-07-29  02:07            28,944 orannzentr9.dll
2006-07-29  02:08            28,944 ORANNZMCS9.DLL
2006-07-29  02:07           586,000 orannzsbb9.dll
2006-07-29  02:07            24,848 oranoname9.dll
2006-07-29  02:08            57,616 oranoncj9.dll
2006-07-29  02:07            45,328 ORANRAD9.DLL
2006-07-29  02:06           225,552 oranro9.dll
2006-07-29  02:08            41,232 oransgr9.dll
2006-07-29  02:06            49,424 orantcp9.dll
2006-07-29  02:07            53,520 ORANTCPS9.DLL
2006-07-29  02:07            28,944 orantns9.dll
2006-07-29  13:58            57,784 oraobjop9.dll
2006-07-29  14:58           311,568 oraocci9.dll
2006-07-29  14:02            24,848 oraodm9.dll
2006-06-26  19:19         2,314,240 oraolapapi9.dll
2006-07-29  13:58            57,784 oraolapop9.dll
2006-07-18  08:53           377,104 oraordim9.dll
2006-07-29  12:39            61,712 ORAPLC9.DLL
2006-07-29  12:40           909,584 ORAPLP9.DLL
2006-07-29  12:39         3,281,168 ORAPLS9.DLL
2006-07-29  13:58            57,784 ORAPRTOP9.DLL
2002-04-26  17:18            28,944 ORASLAX9.DLL
2006-06-28  06:33            69,904 ORASNLS9.DLL
2006-06-28  16:04           483,600 ORASQL9.DLL
2002-04-29  14:04           246,032 oratrace9.dll
2002-04-29  14:04            86,288 oratracepls9.dll
2006-06-28  06:32            69,904 ORAUNLS9.DLL
2006-07-29  14:02            24,848 oravsn9.dll
2005-03-29  17:17            24,576 orawsec9.dll
2006-07-29  14:02            24,848 orawtc9.dll
2001-04-16  19:19           191,248 orawwg9.dll
2006-06-27  01:50           520,464 ORAXML9.DLL
2006-06-27  01:50            41,232 ORAXMLG9.DLL
2006-06-27  01:50           172,304 ORAXSD9.DLL
2002-02-08  21:32           151,552 vspp97.dll
2002-02-08  21:33            65,536 vsqp9.dll
2002-02-08  21:34           122,880 vsw97.dll


要拷贝以上文件很简单，粘贴以上内容编辑成批处理，拷贝到d:\tools\bbed文件夹。
cd D:\oracle\ora92\bin
copy bbed.exe d:\tools\bbed
.....

然后再拷贝到自己的机器，由于11G缺少bbedus.msb,bbedus.msg文件，可以从10g版本获得并拷贝到11G的RDBMS\mesg目录，但是我在使用中还是遇到问题，
无法找到bbedus.msb,bbedus.msg文件，我跟踪发现要设置环境变量，bbed.exe不读注册表。
set ORACLE_HOME=e:\oracle\product\11.1.0\db_1,这样再执行bbed就ok了。
或者当前安装bbed的目录下建立dbms\mesg目录，再拷贝bbedus.msb,bbedus.msg文件到这个目录也可以正常使用。

使用问题：
但是我在使用时，又遇到一个奇怪的问题，会出现偏差1个数据块的情况，
9i下正常，10g，11G都是有偏差。建议在windos下还是拿它来看，而不是修改。

SQL> select rowid from emp where rownum @lookup_rowid AAAQ+jAAEAAAAAeAAA

OBJECT FILE BLOCK ROW
------ ---- ----- ---
69539     4    30   0

但是在bbed里看
set dba 4，31
看到才对。

BBED> set dba 4,31
DBA 0x0100001f (16777247 4,31)

BBED> p *kdbr
rowdata[529]
————
ub1 rowdata[529] @8150 0x2c

BBED> x /rnccntnnn
rowdata[529] @8150
————
flag@8150: 0x2c (KDRHFL, KDRHFF, KDRHFH)
lock@8151: 0×01
cols@8152: 8

col 0[3] @8153: 7369
col 1[5] @8157: SMITH
col 2[5] @8163: CLERK
col 3[3] @8169: 7902
col 4[7] @8173: 1980-12-17 00:00:00
col 5[2] @8181: 800
col 6[0] @8184: *NULL*
col 7[2] @8185: 20