Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all...
Attempt to log into the DB using the 'Use statistics' function.
If only 'On Files' is checked, it will work.
But I want to put the log contents in the DB.
So created a table called ODS_LOGS...
CREATE TABLE ODS_LOGS
(
START_TIME TIMESTAMP ,
VAL1 VARCHAR2(20) ,
VAL2 VARCHAR2(20) ,
VAL3 VARCHAR2(20) ,
CNT1 NUMBER ,
PROJECT_NM1 VARCHAR2(20) ,
JOB_NM1 VARCHAR2(20) ,
VAL4 VARCHAR2(20) ,
VERSION1 NUMBER(2,1) ,
VAL5 VARCHAR2(20) ,
VAL6 VARCHAR2(20) ,
VAL7 VARCHAR2(20) ,
VAL8 VARCHAR2(20) ,
END_TIME TIMESTAMP ,
VAL9 VARCHAR2(20) ,
VAL10 VARCHAR2(20) ,
VAL11 VARCHAR2(20) ,
CNT2 NUMBER ,
PROJECT_NM2 VARCHAR2(20) ,
JOB_NM2 VARCHAR2(20) ,
VAL12 VARCHAR2(20) ,
VERSION2 NUMBER(2,1) ,
VAL13 VARCHAR2(20) ,
VAL14 VARCHAR2(20) ,
STATUS VARCHAR2(20) ,
SUCC_YN VARCHAR2(20) ,
CNT3 NUMBER
)
;
also, create Generic schema...
And..changed option stats_logs...
But.. i got this error...
What should I do?
I'd appreciate your reply.
CREATE TABLE O_JOB_LOG
(
moment TIMESTAMP ,
pid VARCHAR2(20) ,
father_pid VARCHAR2(20) ,
root_pid VARCHAR2(20) ,
system_pid NUMBER(8) ,
project VARCHAR2(50) ,
job VARCHAR2(255) ,
job_repository_id VARCHAR2(255) ,
job_version VARCHAR2(255) ,
context VARCHAR2(50) ,
origin VARCHAR2(255) ,
message_type VARCHAR2(255) ,
message VARCHAR2(255) ,
duration NUMBER(8)
)
THANKS YOU!!