Oracle has the BBED utility (block browser and editor) is is all releases of Oracle, from Oracle7 to Oracle10g,In Oracle 11g, BBED becomes unavailable but if you search in the ins_rdbms.mk makefile (located in $ORACLE_HOME/rdbms/lib directory), you will see that the entry is still there. Designed for internal use only,If you want to use it with an Oracle 11g database, you will have to get some files from an old Oracle 10g installation and build the binary in your Oracle 11g home.
There is a nice document (PDF) about the BBED tool, titled Disassembling the Oracle Data Block which can be found here: PDF
-- in oracle 10g
-- copy bbed_src.tgz to 11g
-- in oracle 11g
TIP:
When you start BBED it will ask you for a password. This password is: blockedit
NOTE:
Do not use BBED on a production database unless one knows what one is doing. Do not use BBED on any database that one cannot afford to lose. Take a backup of any database on which this tool is going to be used.
-- update 2016-6-4 --
build BBED in 12c release 2 same as 11g.
[oracle@anbob bbed]$ bbed
Password: bbededit
BBED: Release 2.0.0.0.0 - Limited Production on Fri Jun 24 17:19:41 2016
Copyright (c) 1982, 2015, Oracle and/or its affiliates. All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************
BBED> ls
BBED-00200: invalid keyword (ls)
BBED> quit
[oracle@anbob bbed]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.0.0 Beta on Fri Jun 24 17:24:11 2016
Copyright (c) 1982, 2015, Oracle. All rights reserved.
There is a nice document (PDF) about the BBED tool, titled Disassembling the Oracle Data Block which can be found here: PDF
-- in oracle 10g
[oracle@testdb ~]$ mkdir bbed
[oracle@testdb ~]$ cd $ORACLE_HOME/rdbms
[oracle@testdb rdbms]$ cd lib
[oracle@testdb lib]$ cp ssbbded.o ~/bbed/
[oracle@testdb lib]$ cp sbbdpt.o ~/bbed/
[oracle@testdb lib]$ cd ../mesg
[oracle@testdb mesg]$ cp bbedus.msb ~/bbed/
[oracle@testdb mesg]$ cp bbedus.msg ~/bbed/
[oracle@testdb mesg]$ cd
[oracle@testdb ~]$ ls
[oracle@testdb ~]$ tar zcvf bbed_src.tgz bbed/
-- copy bbed_src.tgz to 11g
-- in oracle 11g
[oracle@dbserver58 ~]$ tar zxvf bbed_src.tgz
[oracle@dbserver58 ~]$ cd bbed
[oracle@dbserver58 bbed]$ ls
bbedus.msb bbedus.msg sbbdpt.o ssbbded.o
[oracle@dbserver58 bbed]$ cp bbedus.ms* $ORACLE_HOME/rdbms/mesg/
[oracle@dbserver58 bbed]$ cp s* $ORACLE_HOME/rdbms/lib/
[oracle@dbserver58 ~]$ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed
[oracle@dbserver58 ~]$ which bbed
/oracle/product/11.2.0/db_1/bin/bbed
[oracle@dbserver58 ~]$ bbed
Password:
BBED: Release 2.0.0.0.0 - Limited Production on Fri Feb 21 10:34:01 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************
BBED>
TIP:
When you start BBED it will ask you for a password. This password is: blockedit
NOTE:
Do not use BBED on a production database unless one knows what one is doing. Do not use BBED on any database that one cannot afford to lose. Take a backup of any database on which this tool is going to be used.
-- update 2016-6-4 --
build BBED in 12c release 2 same as 11g.
[oracle@anbob bbed]$ bbed
Password: bbededit
BBED: Release 2.0.0.0.0 - Limited Production on Fri Jun 24 17:19:41 2016
Copyright (c) 1982, 2015, Oracle and/or its affiliates. All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************
BBED> ls
BBED-00200: invalid keyword (ls)
BBED> quit
[oracle@anbob bbed]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.0.0 Beta on Fri Jun 24 17:24:11 2016
Copyright (c) 1982, 2015, Oracle. All rights reserved.
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




