Compilation of the Oracle bbed Tool

Bbed is short for block browse block edit. It is a tool used to directly view and modify data files. This tool is not provided on windows. on linux, compilation is required:

Db2-> cd/opt/oracle/product/11.0.13/rdbms/lib
B2-> make-f ins_rdbms.mk $ ORACLE_HOME/rdbms/lib/bbed

Db2->./bbed

Password:

# Default password: blockedit.

BBED: Release 2.0.0.0.0-Limited Production on Wed Aug 12 16:01:03 2009

 

Copyright (c) 1982,200 7, Oracle. All rights reserved.

 

*************!!! For Oracle 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 width character_count

Set count bytes_to_display

Set ibase [HEX | OCT | DEC]

Set obase [HEX | OCT | DEC]

Set mode [BROWSE | EDIT]

Set spool [Y | N]

SHOW [<SET parameter> | 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]

</Nuf>:

N-a number which specifies a repeat count.

U-a letter which specifies a unit size:

B-b1, ub1 (byte)

H-b2, ub2 (half-word)

W-b4, ub4 (word)

R-Oracle table/index row

F-a letter which specifies 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] <target spec >=< source spec>

<Target spec>: [DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | * symbol]

<Source spec>: [value | <target spec options>]

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

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

POP [ALL]

REVERT [DBA | FILE | FILENAME | BLOCK]

UNDO

HELP [<bbed command> | ALL]

VERIFY [DBA | FILE | FILENAME | BLOCK]

CORRUPT [DBA | FILE | FILENAME | BLOCK]

 

BBED>