redo log日誌挖掘(一)

sundog315發表於2010-09-15

從2010年7月開始,公司準備上一個增量ETL工具,領導安排研究一下Oracle 的 redo log 格式,如果可以的話,可以做程式來挖掘,並且生成可執行的SQL,傳遞到目標環境中應用。

各個工作從‎2010‎年‎7‎月‎23‎日開始,到今天,已經2個多月了,中間夾雜了一些事情,導致進展不是很快。現在,讀取、解析的工作已經可以拿來見人了:)

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as test

SQL> insert into t select * from dba_objects where rownum<100;

99 rows inserted

Executed in 0.156 seconds

SQL> update t set owner='AAA';

99 rows updated

Executed in 0.016 seconds

SQL> delete from t;

99 rows deleted

Executed in 0 seconds

SQL> commit;

Commit complete

Executed in 0 seconds

SQL>

挖掘以後的結果:

[@more@]

1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'ICOL$', NULL, 20, 02, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_USER1', NULL, 46, 46, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'CON$', NULL, 28, 28, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'UNDO$', NULL, 15, 15, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'C_COBJ#', NULL, 29, 29, 'CLUSTER', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 05);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_OBJ#', NULL, 03, 03, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'PROXY_ROLE_DATA$', NULL, 25, 25, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_IND1', NULL, 41, 41, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_CDEF2', NULL, 54, 54, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_OBJ5', NULL, 40, 40, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_PROXY_ROLE_DATA$_1', NULL, 26, 26, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'FILE$', NULL, 17, 17, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'UET$', NULL, 13, 08, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_FILE#_BLOCK#', NULL, 09, 09, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_FILE1', NULL, 43, 43, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_CON1', NULL, 51, 51, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_OBJ3', NULL, 38, 38, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_TS#', NULL, 07, 07, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_CDEF4', NULL, 56, 56, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'IND$', NULL, 19, 02, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'SEG$', NULL, 14, 08, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'C_TS#', NULL, 06, 06, 'CLUSTER', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 05);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_FILE2', NULL, 44, 44, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'COL$', NULL, 21, 02, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_TS1', NULL, 45, 45, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_UNDO2', NULL, 35, 35, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'CLU$', NULL, 05, 02, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'PROXY_DATA$', NULL, 23, 23, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_USER2', NULL, 47, 47, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_PROXY_DATA$', NULL, 24, 24, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_OBJ1', NULL, 36, 36, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_COL2', NULL, 49, 49, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_OBJ2', NULL, 37, 37, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_OBJ4', NULL, 39, 39, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_CCOL1', NULL, 57, 57, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'TS$', NULL, 16, 06, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'C_FILE#_BLOCK#', NULL, 08, 08, 'CLUSTER', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 05);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'C_USER#', NULL, 10, 10, 'CLUSTER', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 05);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_UNDO1', NULL, 34, 34, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'BOOTSTRAP$', NULL, 59, 59, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'FET$', NULL, 12, 06, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_TAB1', NULL, 33, 33, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'CCOL$', NULL, 32, 29, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'USER$', NULL, 22, 10, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_CON2', NULL, 52, 52, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_COBJ#', NULL, 30, 30, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'OBJ$', NULL, 18, 18, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_COL3', NULL, 50, 50, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'C_OBJ#', NULL, 02, 02, 'CLUSTER', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 05);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'TAB$', NULL, 04, 02, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'CDEF$', NULL, 31, 29, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_CDEF1', NULL, 53, 53, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_ICOL1', NULL, 42, 42, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_CDEF3', NULL, 55, 55, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_CCOL2', NULL, 58, 58, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_COL1', NULL, 48, 48, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_USER#', NULL, 11, 11, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_PROXY_ROLE_DATA$_2', NULL, 27, 27, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'OBJERROR$', NULL, 60, 60, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'OBJAUTH$', NULL, 61, 61, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_OBJAUTH1', NULL, 62, 62, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_OBJAUTH2', NULL, 63, 63, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'UGROUP$', NULL, 64, 64, 'TABLE', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_UGROUP1', NULL, 65, 65, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_UGROUP2', NULL, 66, 66, 'INDEX', to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:57', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'TSQ$', NULL, 67, 10, 'TABLE', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'SYN$', NULL, 68, 68, 'TABLE', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'VIEW$', NULL, 69, 69, 'TABLE', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'TYPED_VIEW$', NULL, 70, 70, 'TABLE', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'SUPEROBJ$', NULL, 71, 71, 'TABLE', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_SUPEROBJ1', NULL, 72, 72, 'INDEX', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_SUPEROBJ2', NULL, 73, 73, 'INDEX', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'SEQ$', NULL, 74, 74, 'TABLE', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_VIEW1', NULL, 75, 75, 'INDEX', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_TYPED_VIEW1', NULL, 76, 76, 'INDEX', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_SYN1', NULL, 77, 77, 'INDEX', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_SYN2', NULL, 78, 78, 'INDEX', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_SEQ1', NULL, 79, 79, 'INDEX', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'LOB$', NULL, 80, 02, 'TABLE', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_LOB1', NULL, 81, 81, 'INDEX', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_LOB2', NULL, 82, 82, 'INDEX', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'COLTYPE$', NULL, 83, 02, 'TABLE', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_COLTYPE1', NULL, 84, 84, 'INDEX', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_COLTYPE2', NULL, 85, 85, 'INDEX', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'SUBCOLTYPE$', NULL, 86, 02, 'TABLE', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_SUBCOLTYPE1', NULL, 87, 87, 'INDEX', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'NTAB$', NULL, 88, 02, 'TABLE', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_NTAB1', NULL, 89, 89, 'INDEX', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d84,55882,1,929,144,TEST,T,insert into T values ( 'SYS', 'I_NTAB2', NULL, 90, 90, 'INDEX', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d85,55882,1,931,444,TEST,T,insert into T values ( 'SYS', 'I_NTAB3', NULL, 91, 91, 'INDEX', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d85,55882,1,931,444,TEST,T,insert into T values ( 'SYS', 'REFCON$', NULL, 92, 02, 'TABLE', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d85,55882,1,931,444,TEST,T,insert into T values ( 'SYS', 'I_REFCON1', NULL, 93, 93, 'INDEX', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d85,55882,1,931,444,TEST,T,insert into T values ( 'SYS', 'I_REFCON2', NULL, 94, 94, 'INDEX', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d85,55882,1,931,444,TEST,T,insert into T values ( 'SYS', 'OPQTYPE$', NULL, 95, 02, 'TABLE', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d85,55882,1,931,444,TEST,T,insert into T values ( 'SYS', 'I_OPQTYPE1', NULL, 96, 96, 'INDEX', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 04);
1237371,0007000c000001b3,1000d85,55882,1,931,444,TEST,T,insert into T values ( 'SYS', 'UGROUP_SEQUENCE', NULL, 97, NULL, 'SEQUENCE', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d85,55882,1,931,444,TEST,T,insert into T values ( 'SYS', 'PROPS$', NULL, 98, 98, 'TABLE', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d85,55882,1,931,444,TEST,T,insert into T values ( 'SYS', 'EDITION$', NULL, 99, 99, 'TABLE', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 01);
1237371,0007000c000001b3,1000d85,55882,1,931,444,TEST,T,insert into T values ( 'SYS', 'ORA$BASE', NULL, 0100, NULL, 'EDITION', to_date('2010-08-31 12:59:58','yyyy-mm-dd hh24:mi:ss'), to_date('2010-08-31 13:00:20','yyyy-mm-dd hh24:mi:ss'), '2010-08-31:12:59:58', 'VALID', 'N', 'N', 'N', 64);
1237372,0007000c000001b3,1000d84,55882,1,936,304,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 20 ;
1237372,0007000c000001b3,1000d84,55882,1,937,96,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 46 ;
1237372,0007000c000001b3,1000d84,55882,1,937,384,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 28 ;
1237372,0007000c000001b3,1000d84,55882,1,938,176,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 15 ;
1237372,0007000c000001b3,1000d84,55882,1,938,464,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 29 ;
1237372,0007000c000001b3,1000d84,55882,1,939,256,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 03 ;
1237372,0007000c000001b3,1000d84,55882,1,940,48,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 25 ;
1237372,0007000c000001b3,1000d84,55882,1,940,336,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 41 ;
1237372,0007000c000001b3,1000d84,55882,1,941,128,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 54 ;
1237372,0007000c000001b3,1000d84,55882,1,941,416,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 40 ;
1237372,0007000c000001b3,1000d84,55882,1,942,208,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 26 ;
1237372,0007000c000001b3,1000d84,55882,1,942,496,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 17 ;
1237372,0007000c000001b3,1000d84,55882,1,943,304,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 13 ;
1237372,0007000c000001b3,1000d84,55882,1,944,96,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 09 ;
1237372,0007000c000001b3,1000d84,55882,1,944,384,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 43 ;
1237372,0007000c000001b3,1000d84,55882,1,945,176,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 51 ;
1237372,0007000c000001b3,1000d84,55882,1,945,464,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 38 ;
1237372,0007000c000001b3,1000d84,55882,1,946,256,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 07 ;
1237372,0007000c000001b3,1000d84,55882,1,947,48,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 56 ;
1237372,0007000c000001b3,1000d84,55882,1,947,336,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 19 ;
1237372,0007000c000001b3,1000d84,55882,1,948,128,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 14 ;
1237372,0007000c000001b3,1000d84,55882,1,948,416,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 06 ;
1237372,0007000c000001b3,1000d84,55882,1,949,208,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 44 ;
1237372,0007000c000001b3,1000d84,55882,1,949,496,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 21 ;
1237372,0007000c000001b3,1000d84,55882,1,950,304,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 45 ;
1237372,0007000c000001b3,1000d84,55882,1,951,96,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 35 ;
1237372,0007000c000001b3,1000d84,55882,1,951,384,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 05 ;
1237372,0007000c000001b3,1000d84,55882,1,952,176,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 23 ;
1237372,0007000c000001b3,1000d84,55882,1,952,464,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 47 ;
1237372,0007000c000001b3,1000d84,55882,1,953,256,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 24 ;
1237372,0007000c000001b3,1000d84,55882,1,954,48,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 36 ;
1237372,0007000c000001b3,1000d84,55882,1,954,336,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 49 ;
1237372,0007000c000001b3,1000d84,55882,1,955,128,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 37 ;
1237372,0007000c000001b3,1000d84,55882,1,955,416,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 39 ;
1237372,0007000c000001b3,1000d84,55882,1,956,208,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 57 ;
1237372,0007000c000001b3,1000d84,55882,1,956,496,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 16 ;
1237372,0007000c000001b3,1000d84,55882,1,957,304,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 08 ;
1237372,0007000c000001b3,1000d84,55882,1,958,96,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 10 ;
1237372,0007000c000001b3,1000d84,55882,1,958,384,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 34 ;
1237372,0007000c000001b3,1000d84,55882,1,959,176,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 59 ;
1237372,0007000c000001b3,1000d84,55882,1,959,464,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 12 ;
1237372,0007000c000001b3,1000d84,55882,1,960,256,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 33 ;
1237372,0007000c000001b3,1000d84,55882,1,961,48,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 32 ;
1237372,0007000c000001b3,1000d84,55882,1,961,336,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 22 ;
1237372,0007000c000001b3,1000d84,55882,1,962,128,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 52 ;
1237372,0007000c000001b3,1000d84,55882,1,962,416,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 30 ;
1237372,0007000c000001b3,1000d84,55882,1,963,208,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 18 ;
1237372,0007000c000001b3,1000d84,55882,1,963,496,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 50 ;
1237372,0007000c000001b3,1000d84,55882,1,964,364,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 02 ;
1237372,0007000c000001b3,1000d84,55882,1,965,156,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 04 ;
1237372,0007000c000001b3,1000d84,55882,1,965,444,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 31 ;
1237372,0007000c000001b3,1000d84,55882,1,966,236,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 53 ;
1237372,0007000c000001b3,1000d84,55882,1,967,28,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 42 ;
1237372,0007000c000001b3,1000d84,55882,1,967,316,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 55 ;
1237372,0007000c000001b3,1000d84,55882,1,968,108,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 58 ;
1237372,0007000c000001b3,1000d84,55882,1,968,396,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 48 ;
1237372,0007000c000001b3,1000d84,55882,1,969,188,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 11 ;
1237372,0007000c000001b3,1000d84,55882,1,969,476,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 27 ;
1237372,0007000c000001b3,1000d84,55882,1,970,268,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 60 ;
1237372,0007000c000001b3,1000d84,55882,1,971,60,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 61 ;
1237372,0007000c000001b3,1000d84,55882,1,971,348,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 62 ;
1237372,0007000c000001b3,1000d84,55882,1,972,140,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 63 ;
1237372,0007000c000001b3,1000d84,55882,1,972,428,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 64 ;
1237372,0007000c000001b3,1000d84,55882,1,973,220,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 65 ;
1237372,0007000c000001b3,1000d84,55882,1,973,508,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 66 ;
1237372,0007000c000001b3,1000d84,55882,1,974,304,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 67 ;
1237372,0007000c000001b3,1000d84,55882,1,975,96,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 68 ;
1237372,0007000c000001b3,1000d84,55882,1,975,384,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 69 ;
1237372,0007000c000001b3,1000d84,55882,1,976,176,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 70 ;
1237372,0007000c000001b3,1000d84,55882,1,976,464,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 71 ;
1237372,0007000c000001b3,1000d84,55882,1,977,256,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 72 ;
1237372,0007000c000001b3,1000d84,55882,1,978,48,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 73 ;
1237372,0007000c000001b3,1000d84,55882,1,978,336,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 74 ;
1237372,0007000c000001b3,1000d84,55882,1,979,128,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 75 ;
1237372,0007000c000001b3,1000d84,55882,1,979,416,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 76 ;
1237372,0007000c000001b3,1000d84,55882,1,980,208,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 77 ;
1237372,0007000c000001b3,1000d84,55882,1,980,496,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 78 ;
1237372,0007000c000001b3,1000d84,55882,1,981,304,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 79 ;
1237372,0007000c000001b3,1000d84,55882,1,982,96,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 80 ;
1237372,0007000c000001b3,1000d84,55882,1,982,384,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 81 ;
1237372,0007000c000001b3,1000d84,55882,1,983,176,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 82 ;
1237372,0007000c000001b3,1000d84,55882,1,983,464,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 83 ;
1237372,0007000c000001b3,1000d84,55882,1,984,256,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 84 ;
1237372,0007000c000001b3,1000d84,55882,1,985,48,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 85 ;
1237372,0007000c000001b3,1000d84,55882,1,985,336,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 86 ;
1237372,0007000c000001b3,1000d84,55882,1,986,128,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 87 ;
1237372,0007000c000001b3,1000d84,55882,1,986,416,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 88 ;
1237372,0007000c000001b3,1000d84,55882,1,987,208,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 89 ;
1237372,0007000c000001b3,1000d84,55882,1,987,496,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 90 ;
1237373,0007000c000001b3,1000d85,55882,1,988,304,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 91 ;
1237373,0007000c000001b3,1000d85,55882,1,989,96,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 92 ;
1237373,0007000c000001b3,1000d85,55882,1,989,384,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 93 ;
1237373,0007000c000001b3,1000d85,55882,1,990,176,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 94 ;
1237373,0007000c000001b3,1000d85,55882,1,990,464,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 95 ;
1237373,0007000c000001b3,1000d85,55882,1,991,256,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 96 ;
1237373,0007000c000001b3,1000d85,55882,1,992,48,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 97 ;
1237373,0007000c000001b3,1000d85,55882,1,992,336,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 98 ;
1237373,0007000c000001b3,1000d85,55882,1,993,128,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 99 ;
1237373,0007000c000001b3,1000d85,55882,1,993,416,TEST,T,update T set OWNER = 'AAA' WHERE OBJECT_ID = 0100 ;
1237374,0007000c000001b3,1000d84,55882,1,994,428,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'C_OBJ#' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 02 AND DATA_OBJECT_ID = 02 AND OBJECT_TYPE = 'CLUSTER' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 05 ;
1237374,0007000c000001b3,1000d84,55882,1,995,300,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_OBJ#' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 03 AND DATA_OBJECT_ID = 03 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,996,168,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'TAB$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 04 AND DATA_OBJECT_ID = 02 AND OBJECT_TYPE = 'TABLE' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 01 ;
1237374,0007000c000001b3,1000d84,55882,1,997,36,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'CLU$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 05 AND DATA_OBJECT_ID = 02 AND OBJECT_TYPE = 'TABLE' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 01 ;
1237374,0007000c000001b3,1000d84,55882,1,997,404,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'C_TS#' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 06 AND DATA_OBJECT_ID = 06 AND OBJECT_TYPE = 'CLUSTER' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 05 ;
1237374,0007000c000001b3,1000d84,55882,1,998,276,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_TS#' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 07 AND DATA_OBJECT_ID = 07 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,999,216,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'C_FILE#_BLOCK#' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 08 AND DATA_OBJECT_ID = 08 AND OBJECT_TYPE = 'CLUSTER' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 05 ;
1237374,0007000c000001b3,1000d84,55882,1,1000,96,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_FILE#_BLOCK#' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 09 AND DATA_OBJECT_ID = 09 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1000,464,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'C_USER#' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 10 AND DATA_OBJECT_ID = 10 AND OBJECT_TYPE = 'CLUSTER' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 05 ;
1237374,0007000c000001b3,1000d84,55882,1,1001,336,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_USER#' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 11 AND DATA_OBJECT_ID = 11 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1002,204,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'FET$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 12 AND DATA_OBJECT_ID = 06 AND OBJECT_TYPE = 'TABLE' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 01 ;
1237374,0007000c000001b3,1000d84,55882,1,1003,72,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'UET$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 13 AND DATA_OBJECT_ID = 08 AND OBJECT_TYPE = 'TABLE' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 01 ;
1237374,0007000c000001b3,1000d84,55882,1,1003,436,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'SEG$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 14 AND DATA_OBJECT_ID = 08 AND OBJECT_TYPE = 'TABLE' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 01 ;
1237374,0007000c000001b3,1000d84,55882,1,1004,308,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'UNDO$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 15 AND DATA_OBJECT_ID = 15 AND OBJECT_TYPE = 'TABLE' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 01 ;
1237374,0007000c000001b3,1000d84,55882,1,1005,176,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'TS$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 16 AND DATA_OBJECT_ID = 06 AND OBJECT_TYPE = 'TABLE' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 01 ;
1237374,0007000c000001b3,1000d84,55882,1,1006,48,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'FILE$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 17 AND DATA_OBJECT_ID = 17 AND OBJECT_TYPE = 'TABLE' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 01 ;
1237374,0007000c000001b3,1000d84,55882,1,1006,480,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'OBJ$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 18 AND DATA_OBJECT_ID = 18 AND OBJECT_TYPE = 'TABLE' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 01 ;
1237374,0007000c000001b3,1000d84,55882,1,1007,348,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'IND$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 19 AND DATA_OBJECT_ID = 02 AND OBJECT_TYPE = 'TABLE' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 01 ;
1237374,0007000c000001b3,1000d84,55882,1,1008,220,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'ICOL$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 20 AND DATA_OBJECT_ID = 02 AND OBJECT_TYPE = 'TABLE' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 01 ;
1237374,0007000c000001b3,1000d84,55882,1,1009,88,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'COL$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 21 AND DATA_OBJECT_ID = 02 AND OBJECT_TYPE = 'TABLE' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 01 ;
1237374,0007000c000001b3,1000d84,55882,1,1009,456,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'USER$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 22 AND DATA_OBJECT_ID = 10 AND OBJECT_TYPE = 'TABLE' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 01 ;
1237374,0007000c000001b3,1000d84,55882,1,1010,332,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'PROXY_DATA$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 23 AND DATA_OBJECT_ID = 23 AND OBJECT_TYPE = 'TABLE' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 01 ;
1237374,0007000c000001b3,1000d84,55882,1,1011,212,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_PROXY_DATA$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 24 AND DATA_OBJECT_ID = 24 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1012,92,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'PROXY_ROLE_DATA$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 25 AND DATA_OBJECT_ID = 25 AND OBJECT_TYPE = 'TABLE' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 01 ;
1237374,0007000c000001b3,1000d84,55882,1,1012,472,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_PROXY_ROLE_DATA$_1' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 26 AND DATA_OBJECT_ID = 26 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1013,356,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_PROXY_ROLE_DATA$_2' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 27 AND DATA_OBJECT_ID = 27 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1014,224,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'CON$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 28 AND DATA_OBJECT_ID = 28 AND OBJECT_TYPE = 'TABLE' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 01 ;
1237374,0007000c000001b3,1000d84,55882,1,1015,96,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'C_COBJ#' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 29 AND DATA_OBJECT_ID = 29 AND OBJECT_TYPE = 'CLUSTER' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 05 ;
1237374,0007000c000001b3,1000d84,55882,1,1015,464,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_COBJ#' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 30 AND DATA_OBJECT_ID = 30 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1016,336,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'CDEF$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 31 AND DATA_OBJECT_ID = 29 AND OBJECT_TYPE = 'TABLE' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 01 ;
1237374,0007000c000001b3,1000d84,55882,1,1017,208,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'CCOL$' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 32 AND DATA_OBJECT_ID = 29 AND OBJECT_TYPE = 'TABLE' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 01 ;
1237374,0007000c000001b3,1000d84,55882,1,1018,80,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_TAB1' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 33 AND DATA_OBJECT_ID = 33 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1018,448,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_UNDO1' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 34 AND DATA_OBJECT_ID = 34 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1019,320,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_UNDO2' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 35 AND DATA_OBJECT_ID = 35 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1020,192,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_OBJ1' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 36 AND DATA_OBJECT_ID = 36 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1021,64,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_OBJ2' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 37 AND DATA_OBJECT_ID = 37 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1021,432,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_OBJ3' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 38 AND DATA_OBJECT_ID = 38 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1022,304,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_OBJ4' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 39 AND DATA_OBJECT_ID = 39 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1023,176,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_OBJ5' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 40 AND DATA_OBJECT_ID = 40 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1024,48,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_IND1' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 41 AND DATA_OBJECT_ID = 41 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1024,476,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_ICOL1' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 42 AND DATA_OBJECT_ID = 42 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1025,348,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_FILE1' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 43 AND DATA_OBJECT_ID = 43 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1026,288,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_FILE2' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 44 AND DATA_OBJECT_ID = 44 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1027,160,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_TS1' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 45 AND DATA_OBJECT_ID = 45 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1028,32,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_USER1' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 46 AND DATA_OBJECT_ID = 46 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1028,400,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_USER2' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 47 AND DATA_OBJECT_ID = 47 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1029,272,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_COL1' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 48 AND DATA_OBJECT_ID = 48 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1030,144,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_COL2' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 49 AND DATA_OBJECT_ID = 49 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1030,512,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_COL3' AND SUBOBJECT_NAME is NULL AND OBJECT_ID = 50 AND DATA_OBJECT_ID = 50 AND OBJECT_TYPE = 'INDEX' AND CREATED = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND LAST_DDL_TIME = to_date('2010-08-31 12:59:57','yyyy-mm-dd hh24:mi:ss') AND TIMESTAMP = '2010-08-31:12:59:57' AND STATUS = 'VALID' AND TEMPORARY = 'N' AND GENERATED = 'N' AND SECONDARY = 'N' AND NAMESPACE = 04 ;
1237374,0007000c000001b3,1000d84,55882,1,1031,384,TEST,T,delete from T where OWNER = 'AAA' AND OBJECT_NAME = 'I_CON1' AND SUBOBJECT_NAME i

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/19423/viewspace-1038389/,如需轉載,請註明出處,否則將追究法律責任。

相關文章