[20231025]跟踪rename操作2.txt

--//做一个rename 操作，看看主要修改那些数据字典。

1.环境：
SCOTT@book> @ ver1
PORT_STRING         VERSION    BANNER
------------------- ---------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

2.测试：
SCOTT@book> create table deptx as select * from dept;
Table created.

--//分析略.
SCOTT@book> rename deptx to depty;
Table renamed.

SCOTT@book> @ 10046on 12
Session altered.

SCOTT@book> rename depty to deptz;
Table renamed.

SCOTT@book> @ 10046off
Session altered.

SCOTT@book> @ t
TRACEFILE
----------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/book/book/trace/book_ora_61833.trc
--//做两次rename，主要是避免跟踪到一些不必要的递规语句。

3.查看跟踪文件内容：

$ extractsql.sh /u01/app/oracle/diag/rdbms/book/book/trace/book_ora_61833.trc | egrep -i "^delete|^update|^insert"
update ind$ set flags = flags + 8 where obj# = :1
delete from idl_ub1$ where obj#=:1
delete from idl_char$ where obj#=:1
delete from idl_ub2$ where obj#=:1
delete from idl_sb4$ where obj#=:1
delete from error$ where obj#=:1
delete from obj$ where obj# = :1
~~~~~~~~~~~~~~~~~~
insert into obj$(owner#,name,namespace,obj#,type#,ctime,mtime,stime,status,remoteowner,linkname,subname,dataobj#,flags,oid$,spare1,spare2,spare3) values(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18)
~~~~~~~~~~~~~~~~~~
update sdo_geor_sysdata_table set GEORASTER_TABLE_NAME=:1  where GEORASTER_TABLE_NAME=:2
update mdsys.sdo_tin_pc_sysdata_table set TABLE_NAME=:1   where TABLE_NAME=:2 and sdo_owner=:3
update mdsys.sdo_tin_pc_seq set TABLE_NAME=:1   where TABLE_NAME=:2 and sdo_owner=:3

--//主要看下划线的2条DML语句,可以判断rename是先删除再插入obj$,而不是采用update完成的.
--//这也验证了我测试rename IDL_UB1$操作的恢复时出现的情况。

--//附上extractsql.sh脚本:
$cat  extractsql.sh
#! /bin/bash
awk '/PARSING IN CURSOR/,/END OF STMT/' $1 | egrep -v '^PARSING|^END OF STMT'