在10g中连接生成bbed:
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed
11g中缺省未提供BBED库文件,但可以把10g的文件copy到相应目录下,再进行编译
oracle 11g中缺bbed包,oracle11g bbed install and example
上传(sbbdpt.o ssbbded.o bbedus.msb,该三个文件拷贝oracle的linux64版本的)文件
$ORACLE_HOME/rdbms/lib/ssbbded.o
$ORACLE_HOME/rdbms/lib/sbbdpt.o
$ORACLE_HOME/rdbms/mesg/bbedus.msb
$ORACLE_HOME/rdbms/mesg/bbedus.msg
执行如下命令:
cd $ORACLE_HOME/rdbms/lib
make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed
bbed的密码:blockedit
vi parameter.txt
blocksize=8192
listfile=dbfiles.txt
mode=edit
vi dbfiles.txt
select file#||chr(9)||name||chr(9)||bytes from v$datafile;
1 /u01/app/oracle/oradata/test1212/system01.dbf 713031680
2 /u01/app/oracle/oradata/test1212/sysaux01.dbf 524288000
3 /u01/app/oracle/oradata/test1212/undotbs01.dbf 372244480
4 /u01/app/oracle/oradata/test1212/users01.dbf 136314880
5 /u01/app/oracle/oradata/test1212/ss01.dbf 104857600
bbed password=blockedit parfile=/home/oracle/parameter.txt listfile=dbfiles.txt
SYS@ ora11g>select rowid,
dbms_rowid.rowid_relative_fno(rowid)rel_fno,
dbms_rowid.rowid_block_number(rowid)blockno,
dbms_rowid.rowid_row_number(rowid) rowno
from scott.emp;
ROWID REL_FNO BLOCKNO ROWNO
------------------ ---------- ---------- ----------
AAASZHAAEAAAACXAAA 4 151 0
AAASZHAAEAAAACXAAB 4 151 1
AAASZHAAEAAAACXAAC 4 151 2
AAASZHAAEAAAACXAAD 4 151 3
AAASZHAAEAAAACXAAE 4 151 4
AAASZHAAEAAAACXAAF 4 151 5
AAASZHAAEAAAACXAAG 4 151 6
AAASZHAAEAAAACXAAH 4 151 7
AAASZHAAEAAAACXAAI 4 151 8
AAASZHAAEAAAACXAAJ 4 151 9
AAASZHAAEAAAACXAAK 4 151 10
AAASZHAAEAAAACXAAL 4 151 11
AAASZHAAEAAAACXAAM 4 151 12
AAASZHAAEAAAACXAAN 4 151 13
14 rows selected.