C:\Users\Administrator>sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on 星期四 8月 13 14:57:42 2015Copyright (c) 1982, 2010, Oracle. All rights reserved.SQL> conn bbd/bbd
已连接。
SQL>
SQL> set linesize 150 pagesize 100
SQL>
SQL> select rowid,dbms_rowid.rowid_block_number(rowid) rbn,
2 dbms_rowid.rowid_relative_fno(rowid) rrf,
3 dbms_rowid.rowid_row_number(rowid) rrn,
4 ids,
5 lname
6 from t1;ROWID RBN RRF RRN IDS LNAME
------------------ ---------- ---------- ---------- ---------- ---------------
AAAR7QAAFAAAAcEAAA 1796 5 0 100 baidu
AAAR7QAAFAAAAcEAAB 1796 5 1 200 googleSQL>
#########################################################################
进入bbed
BBED> info
File# Name Size(blks)
----- ---- ----------
1 D:\ORACLE\PRODUCT\ORADATA\MYORCL\SYSTEM01.DBF 87040
2 D:\ORACLE\PRODUCT\ORADATA\MYORCL\SYSAUX01.DBF 60160
3 D:\ORACLE\PRODUCT\ORADATA\MYORCL\UNDOTBS01.DBF 9600
4 D:\ORACLE\PRODUCT\ORADATA\MYORCL\USERS01.DBF 640
5 D:\ORACLE\PRODUCT\ORADATA\MYORCL\BBED01.DBF 12800BBED> set dba 5,1796
DBA 0x01400704 (20973316 5,1796)BBED> p
kcbh.type_kcbh
--------------
ub1 type_kcbh @0 0x06BBED> show
FILE# 5
BLOCK# 1796
OFFSET 0
DBA 0x01400704 (20973316 5,1796)
FILENAME D:\ORACLE\PRODUCT\ORADATA\MYORCL\BBED01.DBF
BIFILE bifile.bbd
LISTFILE a.txt
BLOCKSIZE 8192
MODE Edit
EDIT Unrecoverable
IBASE Dec
OBASE Dec
WIDTH 80
COUNT 512
LOGFILE log.bbd
SPOOL NoBBED>
BBED>
BBED> find /c google
BBED-00212: search string not found
BBED> find /c baidu
BBED-00212: search string not found
BBED>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货