BBED Block Browser EDitor for Oracle 11g

BBED (Block Browser Editor) is a tool for Oracle internal use, and it helps you to read and manipulate data at the Oracle Database block level. No need to say that it’s very powerful and also extremely dangerous because you can corrupt data/header blocks. There’s an unofficial but very comprehensive manual for BBED. It’s written by Graham Thornton. You can download it as PDF: http://orafaq.com/papers/dissassembling_the_data_block.pdf

Before Oracle 11g, BBED object code is shipped but you need to compile it to be able to run it. On 11g, the required files to compile BBED is not shipped. So you need to copy the following files from an Oracle 10g home to Oracle 11g home:

What will you do if you don’t have access to any Oracle 10g software home? As you know, Oracle doesn’t provide link to download Oracle 10g anymore. You may open a service request and ask for it, but there’s an easier way: You can get the required files by downloading the 10.2.0.5 patchset from My Oracle Support. Download p8202632_10205_Linux-x86-64.zip, and then issue the following commands (I assume that you have already set the oracle environment variables):

When the files are copied, you can compile bbed utility:

BBED tool will ask you password when you try to run it. It’s not hard to find if you can use GNU debugger. You can even find it if you examine the strings in the file, but I see that it’s not a secret and there are already websites telling the password so here it is: BLOCKEDIT

Be sure to read Graham Thornton’s great manual and be careful when playing with BBED!

Please share
  • 8
  •  
  •  
  •  
  •  
  •  

AWS Big Data Specialist. Oracle Certified Professional (OCP) for EBS R12, Oracle 10g and 11g. Co-author of "Expert Oracle Enterprise Manager 12c" book published by Apress. Awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for the continuous contributions to the Oracle users community. Founding member, and vice president of Turkish Oracle User Group (TROUG). Presented at various international conferences including Oracle Open World.

2 Comments

Leave Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.