& # 160;
<强>欢迎大家加入甲骨文超级群:17115662免费解决各种甲骨文问题,<强>以后的博客将迁移到http://www.htz.pw <强>
& # 160;
www.htz.pw比;select * from v $版本;
& # 160;
旗帜- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
数据库Oracle 11 g企业版发布11.2.0.3.0——64位生产
PL/SQL版本11.2.0.3.0——生产
CORE11.2.0.3.0Production
为Linux TNS:版本11.2.0.3.0 -生产
NLSRTL版本11.2.0.3.0 -生产
www.htz.pw比;创建表斯科特。htz表空间用户select * from dba_objects rownum<2,
& # 160;
创建表。
& # 160;
www.htz.pw比;选择rowid scott.htz;
& # 160;
rowid
- - - - - - - - - - - - - - - - - -
AAASkGAAEAAABkzAAA
& # 160;
www.htz.pw比;@rowid_to_info。sql
输入值rowid: AAASkGAAEAAABkzAAA
ROWID_TYPE: 1
OBJECT_NUMBER: 76038
RELATIVE_FNO: 4
BLOCK_NUMBER: 6451
ROW_NUMBER: 0
& # 160;
PL/sql过程成功完成。
www.htz.pw比;康涅狄格州斯科特/oracle
连接。
www.htz.pw比;选择从htz所有者;
& # 160;
所有者
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
SYS
& # 160;
www.htz.pw比;更新htz组所有者=癏UANGTINGZHONG”;
& # 160;
1行更新。
这里另外打开一个窗口来执行
www.htz.pw比;改变系统冲洗buffer_cache;
& # 160;
系统改变。
& # 160;
www.htz.pw比;选择从scott.htz所有者;
& # 160;
所有者
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
SYS
www.htz.pw比;选择从dba_data_files file_name;
& # 160;
file_name
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
/oracle/app/oracle/oradata/orcl1123/users01。dbf
/oracle/app/oracle/oradata/orcl1123/undotbs1。dbf
/oracle/app/oracle/oradata/orcl1123/sysaux01。dbf
/oracle/app/oracle/oradata/orcl1123/system01。dbf
/oracle/app/oracle/oradata/orcl1123/undotbs2。dbf
/oracle/app/oracle/oradata/orcl1123/htz01。dbf
/oracle/app/oracle/oradata/orcl1123/tbs_data。dbf
/oracle/app/oracle/oradata/orcl1123/undotbs3。dbf
www.htz.pw比;@dump_block。sql
为外部输入值:4
block_id输入值:6451
old1:改变系统转储功能,功能块,block_id
:不丹改变系统转储功能4块6451
& # 160;
系统改变。
块头转储:0 x01001933
对象id> 4, bb
BBED>null
