BBED is shipped with Oracle8 releases, and with some Oracle7.3 releases. BBED is a SUPPORT ONLY tool and should NOT be discussed with customers.
On UNIX the tool needs to be built using a command of the form:
cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed
OR to build in the bn directory:
make -f ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed
On Windows NT a BBED.EXE is shipped as an executable and so is password protected. This password protection is present on Unix from 8.1.6 onwards. @ The password in Oracle8 and Oracle8i is "blockedit"
Using BBED: ~~~~~~~~~~~ A. Command-line Parameters: FILENAME=file to browse/edit BLOCKSIZE= MODE=browse/edit REVERT=y[es]/n[o] SILENT=y[es]/n[o] SPOOL=y[es]/n[o] LISTFILE=list_of_files filename (see format below) CMDFILE=command filename BIFILE=before-image file (default is bifile.bbd) LOGFILE=user logfile (default is log.bbd) PARFILE=parfile HELP=n[o]/y[es]
REVERT use specified (or default) BIFILE to revert changes made in a previous user session. MODE must be EDIT, all files that were modified in that session must be writable.
LOGFILE: appended to an existing file.
LISTFILE format: e.g. 1 /home/vsrihari/corahome/dbs/systV713.dbf 26214400 2 /home/vsrihari/corahome/dbs/rbsV713.dbf 15728640
CMDFILE format: one command per line (newline is command separator). use "#" to put in comments, that are ignored by BBED. if QUIT/EXIT command is encountered BBED exits, otherwise it goes into interactive mode after executing the file.
* can be abbreviated by one letter (X for EXAMINE). - [CHECK]SUM means either CHECKSUM or SUM are valid keywords.
o SET BLOCK or DBA with no arguments just rereads the current block.
o SHOW STACK displays the locations (dba, offset) that were PUSHed.
o IBASE/OBASE are set to decimal by default. Use base switches [/xduoc] or explicit bases to override. Explicit bases have the highest precedence: Hexadecimal (prefix) = 0x e.g. 0x1234abcdef Octal (prefix) = 0o e.g. 0o1234567 Decimal (suffix) = . e.g. 1234567890.
o DUMP/EXAMINE are physical browsing commands, PRINT is logical browsing.
o MODIFY is for physical editing (a la Orapatch). MODE must be set to EDIT to allow editing. All edits are written immediately to disk (no buffering).
o FIND searches only the current block. Use TOP to start search at top of block, CURR (default) from current offset. Typing just FIND (or F) continues looking for the same string.