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


DBA Tips Data Pump Reference


Post a Comment


dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google