![word count in bbedit word count in bbedit](https://us.all.biz/img/us/catalog/5177.jpeg)
The number specified must be one ofthe file ids supplied in the filelist referenced at startup. Sets the current file to the number specified. If successful, bbed will respond showing the filenow being accessed.īBED> set filename '/u01/app/oracle/oradata/dave2/users01.dbf'įILENAME /u01/app/oracle/oradata/dave2/users01.dbf If the file is not in the current path itmust also be fully qualified. It must be a valid Oracle data file andit must be enclosed in single quotes. Sets the current file to the one specified. 如果设置成功,会返回该 block 的 RDBA (Relative Data Block Address) , rdba 就是 rowid 中的 rfile#+block# 。括号里面的是 DBA 值和 block 和 file id 。 我们验证一下:Įxec :dba :=dbms_utility.make_data_block_address(4,145) ĭbms_rowid.rowid_relative_fno(rowid)rel_fno,ĭbms_rowid.rowid_block_number(rowid)blockno,
![word count in bbedit word count in bbedit](http://www.ghacks.net/wp-content/uploads/2012/05/wordpress-word-count.png)
Set the current data block using the standard Oracle DBA ( Data Block Address )format. Sum 计算 block 的 checksum , modify 之后 block 就被标识为坏块, current checksum 与 reqired checksum 不一致, sum 命令可以计算出新的 checksum 并应用到当前块。 U - a letter which specifies a unit size:į - a letter which specifies a displayformat:įIND numeric/character string ĬOPY TO N - a number which specifies a repeatcount. SET OFFSET byte offset | symbol |*symbol ] :/home/oracle> bbed parfile=/home/oracle/bbed.parīBED: Release 2.0.0.0.0 - Limited Production on Tue Apr 5 17:28:35 2016Ĭopyright (c) 1982, 2011, Oracle and/or its affiliates. Please rerun utility with the correct password. Select file#||' '||name||' '||bytes name from v$datafile ībed PASSWORD=blockedit mode=edit blocksize=8192 listfile=/home/oracle/file.txt Make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed