修改块数据-bbed2.pdf
10墨值下载
修改块数据-bbed2.txt
0、编译bbed：
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed
1、查询表的rowid
SQL> select rowid,e.* from emp e;
ROWID EMPNO ENAME JOB MGR HIREDATE
SAL COMM DEPTNO
------------------ ---------- ---------- --------- ---------- ---------
---------- ---------- ----------
AAANEzAAEAAAAAdAAA 7369 SMITH CLERK 7902 17-DEC-80
800 20
AAANEzAAEAAAAAdAAB 7499 ALLEN SALESMAN 7698 20-FEB-81
1600 300 30
AAANEzAAEAAAAAdAAC 7521 WARD SALESMAN 7698 22-FEB-81
1250 500 30
AAANEzAAEAAAAAdAAD 7566 JONES MANAGER 7839 02-APR-81
2975 20
AAANEzAAEAAAAAdAAE 7654 MARTIN SALESMAN 7698 28-SEP-81
1250 1400 30
AAANEzAAEAAAAAdAAF 7698 BLAKE MANAGER 7839 01-MAY-81
2850 30
AAANEzAAEAAAAAdAAG 7782 CLARK MANAGER 7839 09-JUN-81
2450 10
AAANEzAAEAAAAAdAAH 7788 SCOTT ANALYST 7566 19-APR-87
3000 20
AAANEzAAEAAAAAdAAI 7839 KING PRESIDENT 17-NOV-81
5000 10
AAANEzAAEAAAAAdAAJ 7844 TURNER SALESMAN 7698 08-SEP-81
1500 0 30
AAANEzAAEAAAAAdAAK 7876 ADAMS CLERK 7788 23-MAY-87
1100 20
AAANEzAAEAAAAAdAAL 7900 JAMES CLERK 7698 03-DEC-81
950 30
AAANEzAAEAAAAAdAAM 7902 FORD ANALYST 7566 03-DEC-81
3000 20
AAANEzAAEAAAAAdAAN 7934 MILLER CLERK 7782 23-JAN-82
1300 10
2、通过rowid得到文件号和块号
SQL> select DBMS_ROWID.ROWID_RELATIVE_FNO('AAANEzAAEAAAAAdAAA') file_id from
dual;
FILE_ID
----------
4
SQL> select DBMS_ROWID.ROWID_BLOCK_NUMBER('AAANEzAAEAAAAAdAAA') block_id from
dual;
BLOCK_ID
----------
29
第 1 页
Tel：010-88589826 Fax：010-88587520 网址: http://www.cuug.com
修改块数据-bbed2.txt
3、设置文件4，第29块
BBED> set dba 4,29
DBA 0x0100001d (16777245 4,29)
4、使用map查看block结构
BBED> map
File: /home/oracle/oracle/product/10.2.0/oradata/cuug/users01.dbf (4)
Block: 29 Dba:0x0100001d
------------------------------------------------------------
KTB Data Block (Table/Cluster)
struct kcbh, 20 bytes @0
struct ktbbh, 72 bytes @20
struct kdbh, 14 bytes @100
struct kdbt[1], 4 bytes @114
sb2 kdbr[14] @118
ub1 freespace[5754] @146
ub1 rowdata[2288] @5900
ub4 tailchk @8188
5、设置行数据的偏移量
BBED> set offset 5900
OFFSET 5900
6、查看block内容
BBED> d /v
File: /home/oracle/oracle/product/10.2.0/oradata/cuug/users01.dbf (4)
Block: 29 Offsets: 5900 to 6411 Dba:0x0100001d
-------------------------------------------------------
2c000803 c24a4605 534d4954 4805434c l ,...F.SMITH.CL
45524b03 c2500307 77b40c11 01010102 l ERK...w.....
c209ff02 c1152c00 0803c24b 6405414c l ..,...d.AL
4c454e08 53414c45 534d414e 03c24d63 l LEN.SALESMAN.c
0777b502 14010101 02c21102 c20402c1 l .w.......
1f2c0008 03c24c16 04574152 44085341 l .,.....WARD.SA
4c45534d 414e03c2 4d630777 b5021601 l LESMAN.c.w..
010103c2 0d3302c2 0602c11f 2c000803 l ...3..,...
c24c4305 4a4f4e45 53074d41 4e414745 l C.JONES.MANAGE
5203c24f 280777b5 04020101 0103c21e l R.(.w.....
4cff02c1 152c0008 03c24d37
064d4152 l L..,...7.MAR
54494e08 53414c45 534d414e 03c24d63 l TIN.SALESMAN.c
0777b509 1c010101 03c20d33 02c20f02 l .w.....3..
c11f2c00 0803c24d 6305424c 414b4507 l ,...c.BLAKE.
4d414e41 47455203 c24f2807 77b50501 l MANAGER.(.w.
第 2 页
Tel：010-88589826 Fax：010-88587520 网址: http://www.cuug.com
of 4
10墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论