Oracle BBED (oracle block browser and editor tool)Installation and Use
BBEDTools can be used to change dataBlockBut not officially supported.
The installation process is as follows:
$Cd $ ORACLE_HOME/rdbms/lib
$Ls-al * bb *. o
-Rw-r --1 oracleOinstall1671 May 10 2008Sbbdpt. o
-Rw-r --1 oracleOinstall900 May 10 2008Ssbbded. o
$Make-f ins_rdbms.mk $ ORACLE_HOME/rdbms/lib/bbed
Linking BBED utility (bbed)
Rm-f/u01/app/oracle/product/10.2.0/db_1/rdbms/lib/bbed
Ld-b64-o/u01/app/oracle/product/10.2.0/db_1/rdbms/lib/bbed-L/u01/app/oracle/product/10.2.0/db_1/rdbms/ lib/-L/u01/app/oracle/product/10.2.0/db_1/lib/-bnoerrmsg/u01/app/oracle/product/10.2.0/db_1/lib/s0main. o/u01/app/oracle/product/10.2.0/db_1/rdbms/lib/ssbbded. o/u01/app/oracle/product/10.2.0/db_1/rdbms/lib/sbbdpt. o-bI:/usr/lib/aio. exp 'cat/u01/app/oracle/product/10.2.0/db_1/lib/ldflags'-Lnsslb10-lncrypt10-lnsgr10-lnzjs10-ln10-lnnz10-lnl10/u01/app/oracle/product/10.2.0/db_1/rdbms/lib/defopt. o-ldbtools10'Cat/u01/app/oracle/product/10.2.0/db_1/lib/ldflags'-Lnsslb10-lncrypt10-lnsgr10-lnzjs10-ln10-lnnz10-lnl10-lnro10 'cat/u01/app/oracle/product/10.2.0/db_1/lib/ldflags'-Lnsslb10-lncrypt10-lnsgr10-lnzjs10-ln10-lnnz10-lnl10-lclient10-lnnetd10-Lvsn10-lcommon10-lgeneric10-lmm-lsnls10-lnls10-Lcore10-extract-lnls10-lcore10-lsnls10-lnls10-lxml10-lcore10-lunls10-lsnls10-lnls10-lcore10-lnls10 'cat/u01/app/oracle/product/10.2.0/db_1 /lib/ldflags'-Lnsslb10-lncrypt10-lnsgr10-lnzjs10-ln10-lnnz10-lnl10-lnro10 'cat/u01/app/oracle/product/10.2.0/db_1/lib/ldflags'-Lnsslb10-lncrypt10-lnsgr10-lnzjs10-ln10-lnnz10-lnl10-lclient10-lnnetd10-Lvsn10-lcommon10-lgeneric10-lpls10-Lsnls10-lnls10-Lcore10-lsnls10-lnls10-lcore10-lsnls10-lnls10-lxml10-lcore10-lunls10-lsnls10-lnls10-lcore10-lnls10-lclient10-lnnetd10-Lvsn10-lcommon10-lgeneric10-lsnls10-lnls10-Lcore10-lsnls10-lnls10-lcore10-lsnls10-lnls10-lxml10-lcore10-lunls10-lsnls10-lnls10-lcore10-lnls10-Lld-lm 'cat/u01/app/oracle/product/10.2.0/db_1/lib/sysliblist'-Lm'If ["\ '/usr/bin/uname-v \'" = "4"]; then echo "-bI: /u01/app/oracle/product/10.2.0/db_1/lib/pw-syscall.exp "; fi; '-lsql10/U01/app/oracle/product/10.2.0/db_1/lib/nautab. o/u01/app/oracle/product/10.2.0/db_1/lib/naeet. o/u01/app/oracle/product/10.2.0/db_1/lib/naect. o/u01/app/oracle/product/10.2.0/db_1/lib/naedhs. o
$Cp $ ORACLE_HOME/rdbms/lib/bbed $ ORACLE_HOME/bin
$Bbed
Password:<Blockedit>
BBED: Release 2.0.0.0.0-Limited Production on Mon Jun 20 20:00:06 2011
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>