使用BBED修改表数据

bbed可以直接修改block上的内容
模拟环境：
SQL> select * from goolen;

        ID NAME
---------- --------------------
         1 GOOLEN
         2 ORACLE

SQL> select
  2  dbms_rowid.rowid_relative_fno(rowid) file_number,
  3  dbms_rowid.rowid_block_number(rowid) block_number,
  4  id,name
  5  from goolen;

FILE_NUMBER BLOCK_NUMBER         ID NAME
----------- ------------ ---------- --------------------
          4          172          1 GOOLEN
          4          172          2 ORACLE

--我们把id=1的这一列，name值改为ORACLE
[oracle@localhost bbed]$ bbed parfile=bbed.par 
Password: 

BBED: Release 2.0.0.0.0 - Limited Production on Thu Oct 24 10:17:18 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************

BBED> info
 File#  Name                                                        Size(blks)
 -----  ----                                                        ----------
     1  /opt/app/oracle/oradata/goolen/system01.dbf                      87040
     2  /opt/app/oracle/oradata/goolen/sysaux01.dbf                      71680
     3  /opt/app/oracle/oradata/goolen/undotbs01.dbf                      3840
     4  /opt/app/oracle/oradata/goolen/users01.dbf                        7040

BBED> set dba 4,172
        DBA             0x010000ac (16777388 4,172)

--/c 直接查找字符串，确定这一行在block中的偏移量offset
BBED> f /c GOOLEN
 File: /opt/app/oracle/oradata/goolen/users01.dbf (4)
 Block: 172              Offsets: 8182 to 8191           Dba:0x010000ac
------------------------------------------------------------------------
 474f4f4c 454e0206 5fd4 
 <32 bytes per line>

--dump查看具体的内容
BBED> d /v dba 4,172 offset 8182 count 32
 File: /opt/app/oracle/oradata/goolen/users01.dbf (4)
 Block: 172     Offsets: 8182 to 8191  Dba:0x010000ac
-------------------------------------------------------
 474f4f4c 454e0206 5fd4              l GOOLEN.._?
 <16 bytes per line>

--修改
BBED> modify /c ORACLE dba 4,172 offset 8182
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y
 File: /opt/app/oracle/oradata/goolen/users01.dbf (4)
 Block: 172              Offsets: 8182 to 8191           Dba:0x010000ac
------------------------------------------------------------------------
 4f524143 4c450206 5fd4 
 <32 bytes per line>

--再次dump查看内容
BBED> d /v dba 4,172 offset 8182 count 32
 File: /opt/app/oracle/oradata/goolen/users01.dbf (4)
 Block: 172     Offsets: 8182 to 8191  Dba:0x010000ac
-------------------------------------------------------
 4f524143 4c450206 5fd4              l ORACLE.._?
 <16 bytes per line>

BBED> sum apply
Check value for File 4, Block 172:
current = 0xe3c7, required = 0xe3c7

--刷新，查看表数据
SQL> alter system flush buffer_cache;
System altered.

--数据已经被更改
SQL> select rowid,g.* from goolen g;
ROWID                      ID NAME
------------------ ---------- --------------------
AAASNRAAEAAAACsAAA          1 ORACLE
AAASNRAAEAAAACsAAB          2 ORACLE

--回滚所有操作
BBED> revert  
All changes made in this session will be rolled back. Proceed? (Y/N) y
Reverted file '/opt/app/oracle/oradata/goolen/users01.dbf', block 172
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y

BBED> 
--再次刷新
SQL> alter system flush buffer_cache;
System altered.

SQL> select rowid,g.* from goolen g;
ROWID                      ID NAME
------------------ ---------- --------------------
AAASNRAAEAAAACsAAA          1 GOOLEN
AAASNRAAEAAAACsAAB          2 ORACLE

SQL>