Oracle bbed工具的编译

Bbed就是英文block browse block edit的缩写，用来直接查看和修改数据文件数据的一个工具。在windows上没有提供这个工具，在 linux 上面有，需要编译：

db2-> cd/opt/oracle/product/11.0.13/rdbms/lib

b2->  make -f ins_rdbms.mk$ORACLE_HOME/rdbms/lib/bbed

db2-> ./bbed

Password:

#默认的密码:blockedit.

BBED: Release2.0.0.0.0 - Limited Production on Wed Aug 12 16:01:03 2009

Copyright (c) 1982,2007, Oracle.  All rights reserved.

************* !!! ForOracle Internal Use only !!! ***************

BBED> help all

SET DBA [ dba |file#, block# ]

SET FILENAME\'filename\'

SET FILE file#

SET BLOCK [+/-]block#

SET OFFSET [[+/-]byte offset | symbol | *symbol ]

SET BLOCKSIZE bytes

SET LIST[FILE]\'filename\'

SET WIDTHcharacter_count

SET COUNTbytes_to_display

SET IBASE [ HEX | OCT| DEC ]

SET OBASE [ HEX | OCT| DEC ]

SET MODE  [ BROWSE | EDIT ]

SET SPOOL [ Y | N ]

SHOW [ | ALL ]

INFO

MAP[/v] [ DBA |FILENAME | FILE | BLOCK ]

DUMP[/v] [ DBA |FILENAME | FILE | BLOCK | OFFSET | COUNT ]

PRINT[/x|d|u|o|c] [DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | *symbol ]

EXAMINE[/Nuf] [ DBA |FILE | FILENAME | BLOCK | OFFSET | symbol | *symbol ]

:

N - a number whichspecifies a repeat count.

u - a letter whichspecifies a unit size:

b - b1, ub1 (byte)

h - b2, ub2 (half-word)

w - b4, ub4(word)

r - Oracle table/index row

f - a letter whichspecifies a display format:

x - hexadecimal

d - decimal

u - unsigned decimal

o - octal

c - character (native)

n - Oracle number

t - Oracle date

i - Oracle rowid

FIND[/x|d|u|o|c]numeric/character string [ TOP | CURR ]

COPY [ DBA | FILE |FILENAME | BLOCK ] TO [ DBA | FILE | FILENAME | BLOCK ]

MODIFY[/x|d|u|o|c]numeric/character string

[ DBA | FILE | FILENAME | BLOCK | OFFSET| symbol | *symbol ]

ASSIGN[/x|d|u|o] =

:[ DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | *symbol ]

:[ value | ]

SUM [ DBA | FILE |FILENAME | BLOCK ] [ APPLY ]

PUSH [ DBA | FILE |FILENAME | BLOCK | OFFSET ]

POP [ALL]

REVERT [ DBA | FILE |FILENAME | BLOCK ]

UNDO

HELP [ | ALL ]

VERIFY [ DBA | FILE |FILENAME | BLOCK ]

CORRUPT [ DBA | FILE| FILENAME | BLOCK ]

BBED>

这边说下大家在使用此 工具 要非常的小心,毕竟是内容工具,oracle不提供技术支持.

觉得文章有用？立即：和朋友一起 共学习 共进步！

建议继续学习：

1. 安装BBED    (阅读：1541)

QQ技术交流群：445447336，欢迎加入！

扫一扫订阅我的微信号：IT技术博客大学习