Oracle logmnr簡單測試
1.檢視補充日誌資訊
select SUPPLEMENTAL_LOG_DATA_MIN min, SUPPLEMENTAL_LOG_DATA_PK pk, SUPPLEMENTAL_LOG_DATA_UI ui, SUPPLEMENTAL_LOG_DATA_FK fk, SUPPLEMENTAL_LOG_DATA_ALL "all" from v$database;
MIN PK UI FK all -------- --- --- --- --- NO NO NO NO NO
2.開啟最小補充日誌
alter database add supplemental log data;
對應告警日誌:
Thu Aug 26 17:02:19 2021 alter database add supplemental log data SUPLOG: Previous supplemental logging attributes at scn = 4987183 SUPLOG: minimal = OFF, primary key = OFF SUPLOG: unique = OFF, foreign key = OFF, all column = OFF SUPLOG: procedural replication = OFF SUPLOG: New supplemental logging attributes at scn = 4987183 SUPLOG: minimal = ON, primary key = OFF SUPLOG: unique = OFF, foreign key = OFF, all column = OFF SUPLOG: procedural replication = OFF Completed: alter database add supplemental log data
3.建立測試資料
conn test/test create table test1 as select level id,'a' as col1 from dual connect by level<=100; create table test2 as select * from test1; alter system switch logfile; truncate table test1; insert into test1 select * from test1; commit; alter system switch logfile;
4. 檢視歸檔資訊
SQL> ho ls /arch exam2_1_183_1075828699.arc exam2_1_184_1075828699.arc
5.日誌挖掘
SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LogFileName=>'/arch/exam2_1_184_1075828699.arc',Options=>dbms_logmnr.new); ---追加 EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LogFileName=>'/arch/exam2_1_144_1075828699.arc',Options=>dbms_logmnr.addfile); SQL> exec dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog); SQL> create table test3 as select * from v$logmnr_contents; SQL> exec dbms_logmnr.end_logmnr;
6.檢視挖掘資料
select scn, timestamp, username, session#, serial#, sql_redo, sql_undo, operation from test3 where lower(sql_redo) like '%test1%';
SCNTIMESTAMPUSERNAMESESSION#SERIAL#SQL_REDOSQL_UNDOOPERATION 149912652021/8/26 17:28:43TEST38717893"truncate table test1;"DDL 249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('1','a');delete from "TEST"."TEST1" where "ID" = '1' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAA';INSERT 349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('2','a');delete from "TEST"."TEST1" where "ID" = '2' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAB';INSERT 449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('3','a');delete from "TEST"."TEST1" where "ID" = '3' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAC';INSERT 549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('4','a');delete from "TEST"."TEST1" where "ID" = '4' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAD';INSERT 649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('5','a');delete from "TEST"."TEST1" where "ID" = '5' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAE';INSERT 749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('6','a');delete from "TEST"."TEST1" where "ID" = '6' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAF';INSERT 849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('7','a');delete from "TEST"."TEST1" where "ID" = '7' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAG';INSERT 949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('8','a');delete from "TEST"."TEST1" where "ID" = '8' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAH';INSERT 1049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('9','a');delete from "TEST"."TEST1" where "ID" = '9' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAI';INSERT 1149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('10','a');delete from "TEST"."TEST1" where "ID" = '10' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAJ';INSERT 1249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('11','a');delete from "TEST"."TEST1" where "ID" = '11' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAK';INSERT 1349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('12','a');delete from "TEST"."TEST1" where "ID" = '12' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAL';INSERT 1449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('13','a');delete from "TEST"."TEST1" where "ID" = '13' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAM';INSERT 1549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('14','a');delete from "TEST"."TEST1" where "ID" = '14' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAN';INSERT 1649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('15','a');delete from "TEST"."TEST1" where "ID" = '15' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAO';INSERT 1749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('16','a');delete from "TEST"."TEST1" where "ID" = '16' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAP';INSERT 1849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('17','a');delete from "TEST"."TEST1" where "ID" = '17' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAQ';INSERT 1949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('18','a');delete from "TEST"."TEST1" where "ID" = '18' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAR';INSERT 2049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('19','a');delete from "TEST"."TEST1" where "ID" = '19' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAS';INSERT 2149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('20','a');delete from "TEST"."TEST1" where "ID" = '20' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAT';INSERT 2249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('21','a');delete from "TEST"."TEST1" where "ID" = '21' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAU';INSERT 2349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('22','a');delete from "TEST"."TEST1" where "ID" = '22' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAV';INSERT 2449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('23','a');delete from "TEST"."TEST1" where "ID" = '23' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAW';INSERT 2549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('24','a');delete from "TEST"."TEST1" where "ID" = '24' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAX';INSERT 2649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('25','a');delete from "TEST"."TEST1" where "ID" = '25' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAY';INSERT 2749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('26','a');delete from "TEST"."TEST1" where "ID" = '26' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAZ';INSERT 2849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('27','a');delete from "TEST"."TEST1" where "ID" = '27' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAa';INSERT 2949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('28','a');delete from "TEST"."TEST1" where "ID" = '28' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAb';INSERT 3049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('29','a');delete from "TEST"."TEST1" where "ID" = '29' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAc';INSERT 3149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('30','a');delete from "TEST"."TEST1" where "ID" = '30' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAd';INSERT 3249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('31','a');delete from "TEST"."TEST1" where "ID" = '31' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAe';INSERT 3349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('32','a');delete from "TEST"."TEST1" where "ID" = '32' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAf';INSERT 3449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('33','a');delete from "TEST"."TEST1" where "ID" = '33' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAg';INSERT 3549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('34','a');delete from "TEST"."TEST1" where "ID" = '34' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAh';INSERT 3649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('35','a');delete from "TEST"."TEST1" where "ID" = '35' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAi';INSERT 3749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('36','a');delete from "TEST"."TEST1" where "ID" = '36' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAj';INSERT 3849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('37','a');delete from "TEST"."TEST1" where "ID" = '37' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAk';INSERT 3949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('38','a');delete from "TEST"."TEST1" where "ID" = '38' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAl';INSERT 4049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('39','a');delete from "TEST"."TEST1" where "ID" = '39' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAm';INSERT 4149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('40','a');delete from "TEST"."TEST1" where "ID" = '40' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAn';INSERT 4249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('41','a');delete from "TEST"."TEST1" where "ID" = '41' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAo';INSERT 4349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('42','a');delete from "TEST"."TEST1" where "ID" = '42' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAp';INSERT 4449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('43','a');delete from "TEST"."TEST1" where "ID" = '43' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAq';INSERT 4549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('44','a');delete from "TEST"."TEST1" where "ID" = '44' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAr';INSERT 4649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('45','a');delete from "TEST"."TEST1" where "ID" = '45' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAs';INSERT 4749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('46','a');delete from "TEST"."TEST1" where "ID" = '46' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAt';INSERT 4849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('47','a');delete from "TEST"."TEST1" where "ID" = '47' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAu';INSERT 4949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('48','a');delete from "TEST"."TEST1" where "ID" = '48' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAv';INSERT 5049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('49','a');delete from "TEST"."TEST1" where "ID" = '49' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAw';INSERT 5149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('50','a');delete from "TEST"."TEST1" where "ID" = '50' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAx';INSERT 5249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('51','a');delete from "TEST"."TEST1" where "ID" = '51' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAy';INSERT 5349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('52','a');delete from "TEST"."TEST1" where "ID" = '52' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAz';INSERT 5449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('53','a');delete from "TEST"."TEST1" where "ID" = '53' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA0';INSERT 5549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('54','a');delete from "TEST"."TEST1" where "ID" = '54' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA1';INSERT 5649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('55','a');delete from "TEST"."TEST1" where "ID" = '55' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA2';INSERT 5749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('56','a');delete from "TEST"."TEST1" where "ID" = '56' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA3';INSERT 5849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('57','a');delete from "TEST"."TEST1" where "ID" = '57' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA4';INSERT 5949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('58','a');delete from "TEST"."TEST1" where "ID" = '58' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA5';INSERT 6049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('59','a');delete from "TEST"."TEST1" where "ID" = '59' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA6';INSERT 6149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('60','a');delete from "TEST"."TEST1" where "ID" = '60' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA7';INSERT 6249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('61','a');delete from "TEST"."TEST1" where "ID" = '61' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA8';INSERT 6349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('62','a');delete from "TEST"."TEST1" where "ID" = '62' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA9';INSERT 6449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('63','a');delete from "TEST"."TEST1" where "ID" = '63' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA+';INSERT 6549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('64','a');delete from "TEST"."TEST1" where "ID" = '64' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA/';INSERT 6649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('65','a');delete from "TEST"."TEST1" where "ID" = '65' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABA';INSERT 6749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('66','a');delete from "TEST"."TEST1" where "ID" = '66' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABB';INSERT 6849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('67','a');delete from "TEST"."TEST1" where "ID" = '67' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABC';INSERT 6949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('68','a');delete from "TEST"."TEST1" where "ID" = '68' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABD';INSERT 7049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('69','a');delete from "TEST"."TEST1" where "ID" = '69' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABE';INSERT 7149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('70','a');delete from "TEST"."TEST1" where "ID" = '70' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABF';INSERT 7249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('71','a');delete from "TEST"."TEST1" where "ID" = '71' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABG';INSERT 7349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('72','a');delete from "TEST"."TEST1" where "ID" = '72' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABH';INSERT 7449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('73','a');delete from "TEST"."TEST1" where "ID" = '73' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABI';INSERT 7549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('74','a');delete from "TEST"."TEST1" where "ID" = '74' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABJ';INSERT 7649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('75','a');delete from "TEST"."TEST1" where "ID" = '75' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABK';INSERT 7749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('76','a');delete from "TEST"."TEST1" where "ID" = '76' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABL';INSERT 7849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('77','a');delete from "TEST"."TEST1" where "ID" = '77' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABM';INSERT 7949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('78','a');delete from "TEST"."TEST1" where "ID" = '78' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABN';INSERT 8049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('79','a');delete from "TEST"."TEST1" where "ID" = '79' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABO';INSERT 8149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('80','a');delete from "TEST"."TEST1" where "ID" = '80' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABP';INSERT 8249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('81','a');delete from "TEST"."TEST1" where "ID" = '81' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABQ';INSERT 8349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('82','a');delete from "TEST"."TEST1" where "ID" = '82' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABR';INSERT 8449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('83','a');delete from "TEST"."TEST1" where "ID" = '83' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABS';INSERT 8549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('84','a');delete from "TEST"."TEST1" where "ID" = '84' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABT';INSERT 8649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('85','a');delete from "TEST"."TEST1" where "ID" = '85' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABU';INSERT 8749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('86','a');delete from "TEST"."TEST1" where "ID" = '86' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABV';INSERT 8849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('87','a');delete from "TEST"."TEST1" where "ID" = '87' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABW';INSERT 8949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('88','a');delete from "TEST"."TEST1" where "ID" = '88' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABX';INSERT 9049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('89','a');delete from "TEST"."TEST1" where "ID" = '89' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABY';INSERT 9149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('90','a');delete from "TEST"."TEST1" where "ID" = '90' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABZ';INSERT 9249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('91','a');delete from "TEST"."TEST1" where "ID" = '91' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABa';INSERT 9349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('92','a');delete from "TEST"."TEST1" where "ID" = '92' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABb';INSERT 9449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('93','a');delete from "TEST"."TEST1" where "ID" = '93' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABc';INSERT 9549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('94','a');delete from "TEST"."TEST1" where "ID" = '94' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABd';INSERT 9649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('95','a');delete from "TEST"."TEST1" where "ID" = '95' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABe';INSERT 9749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('96','a');delete from "TEST"."TEST1" where "ID" = '96' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABf';INSERT 9849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('97','a');delete from "TEST"."TEST1" where "ID" = '97' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABg';INSERT 9949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('98','a');delete from "TEST"."TEST1" where "ID" = '98' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABh';INSERT 10049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('99','a');delete from "TEST"."TEST1" where "ID" = '99' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABi';INSERT 10149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('100','a');delete from "TEST"."TEST1" where "ID" = '100' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABj';INSERT
#####chenjuchao 2021-08-26 18:50#####
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29785807/viewspace-2789038/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 使用python對oracle進行簡單效能測試PythonOracle
- 【Oracle19c】Oracle19c rman使用簡單測試Oracle
- DBA手記(學習) – LOGMNR 簡單而強大的工具
- 簡單的 ping 測試
- mysql簡單效能測試MySql
- try的簡單效能測試
- Jmeter效能測試簡單使用JMeter
- 建立簡單的表測試
- 【PG效能測試】pgbench效能測試工具簡單使用
- InnoSetup簡單教程一,安裝使用和簡單測試
- 讓 API 測試變的簡單API
- Hibernate對注入的簡單測試
- C++ 巢狀類簡單測試C++巢狀
- Python容器相關簡單效能測試Python
- 簡單的神經網路測試神經網路
- [20190301]簡單測試linux fsfreeze命令.txtLinux
- 如何寫好測試用例以及go單元測試工具testify簡單介紹Go
- Oracle replayc測試Oracle
- WPF 分隔欄分割窗體簡單測試
- 一個簡單的介面測試框架 demo框架
- 移動效能測試---工具PerfDog簡單使用
- [20190423]簡單測試latch nowilling等待模式.txt模式
- [20190211]簡單測試埠是否開啟.txt
- 測試 之Java單元測試、Android單元測試JavaAndroid
- 記一次想簡單化的單元測試
- 換種思路寫Mock,讓單元測試更簡單Mock
- 記一次簡單的vue元件單元測試Vue元件
- ORACLE壓力測試Oracle
- Oracle TDE加密測試Oracle加密
- C++ 虛解構函式簡單測試C++函式
- 最簡單的微服務部署測試實踐微服務
- Testing Flutter apps翻譯-單元測試簡介FlutterAPP
- Golang之wait.Until 簡單測試用例GolangAI
- 簡單聊聊智慧硬體的韌體測試
- 簡單談一下我對持續測試下的測試左移、迭代測試和測試右移的理解吧
- 單元測試:單元測試中的mockMock
- Oracle OCP(51):簡單審計Oracle
- C++ const void * 型別轉換簡單測試C++型別