What is Oracle BBED Tool? How to make it Available in Oracle 11g?

_____________________________________________________________________________________________________________________

BBED: Block Browser and Edit Tool

It is an Oracle tool to check the internal structure of the Oracle blocks. You have to use this tool very carefully as it can damage the Oracle blocks as well as the Oracle database too. This tool allows editing the blocks of the datafiles and it overrides the oracle access.

Generally you have to use this tool with the support of Metalink SR support.

How to make it Available in Oracle 11g?

Normally, it is not available with Oracle 11g. You have to copy the respective files from the Oracle 10g Home and like it with Oracle 11g.

The files need to be copied from Oracle 10g to Oracle 11g:

1.  $ORACLE_HOME/rdbms/lib/ssbbded.o

2.  $ORACLE_HOME/rdbms/lib/sbbdpt.o

3.  $ORACLE_HOME/rdbms/mesg/bbedus.msb

4.  $ORACLE_HOME/rdbms/mesg/bbedus.msg

Set the ORACLE_HOME variables for the Oracle 11g and link these files to Oracle Home.

make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk

BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed

Start the BBED utility and default password would be blockedit

$ORACLE_HOME/bin/bbed

$ORACLE_HOME/bin/bbed

Password:

_____________________________________________________________________________________________________________________

Website Stats