1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
| CREATE TABLE AUDIT_EVENT_TEST(
EVENT_ID VARCHAR2(64) NOT NULL,
USER_NAME VARCHAR2(255 CHAR),
START_TIMESTAMP DATE,
DURATION NUMBER(38),
EVENT_TYPE_ID NUMBER(38),
SERVER_CUID VARCHAR2(64),
OBJECT_CUID VARCHAR2(64),
OBJECT_TYPE VARCHAR2(255 CHAR),
ERROR_CODE NUMBER(38),
OBJECT_ID NUMBER(38)
) tablespace TAB_INF_01
/
CREATE TABLE AUDIT_DETAIL_TEST(
EVENT_ID VARCHAR2(64) NOT NULL,
DETAIL_ID NUMBER(38) NOT NULL,
SERVER_CUID VARCHAR2(64),
DETAIL_TYPE_ID NUMBER(38),
DETAIL_TEXT CLOB,
FLAG VARCHAR2(1)
) tablespace TAB_INF_01
/
DECLARE
a number(2);
b number(2);
N number (20);
ID_E number (20);
ID_D number(20);
BEGIN
ID_E := 10000000000000000000;
N := 10;
FOR a in 1 .. N LOOP
ID_D := 1;
INSERT INTO AUDIT_EVENT_TEST(EVENT_ID) VALUES(ID_E);
FOR b in 1 .. 6 LOOP
INSERT INTO AUDIT_DETAIL_TEST(EVENT_ID, DETAIL_ID) VALUES(ID_E, ID_D);
ID_D := ID_D + 1;
END LOOP;
ID_E := ID_E + 1;
commit;
END LOOP;
END; |
Partager