1.创建日志表
create table PAREBIDATA.LOG_RUN_CONFIG(
log_id NUMBER not null,
program_name VARCHAR2(200),
step_no VARCHAR2(200),
begin_time DATE not null,
end_time DATE,
state_flag VARCHAR2(20) not null,
run_info VARCHAR2(200),
user_id VARCHAR2(50),
created_by VARCHAR2(50) default USER not null,
created_time DATE default SYSDATE not null,
updated_by VARCHAR2(50) default USER not null,
updated_time DATE default SYSDATE not null,
sqldess VARCHAR2(4000),
parameter VARCHAR2(4000)
);
-- Add comments to the table
comment on table PAREBIDATA.LOG_RUN_CONFIG
is '程序运行情况记录表';
-- Add comments to the columns
comment on column PAREBIDATA.LOG_RUN_CONFIG.log_id
is 'ID';
comment on column PAREBIDATA.LOG_RUN_CONFIG.program_name
is '运行程序名';
comment on column PAREBIDATA.LOG_RUN_CONFIG.begin_time
is '运行开始时间';
comment on column PAREBIDATA.LOG_RUN_CONFIG.end_time
is '运行结束时间';
comment on column PAREBIDATA.LOG_RUN_CONFIG.state_flag
is '程序运行状态';
comment on column PAREBIDATA.LOG_RUN_CONFIG.run_info
is '程序运行信息';
comment on column PAREBIDATA.LOG_RUN_CONFIG.step_no
is '程序运行到具体哪一步';
comment on column PAREBIDATA.LOG_RUN_CONFIG.user_id
is '数据库用户';
comment on column PAREBIDATA.LOG_RUN_CONFIG.sqldess
is 'SQL代码号';
comment on column PAREBIDATA.LOG_RUN_CONFIG.parameter
is '运行参数';
-- Create sequence
create sequence PAREBIDATA.PRO_RUN_LOG_SEQUENCE PAREBIDATA
minvalue 1
maxvalue 9999999999999999999999999999
start with 1
increment by 1
cache 20;
-- Grant/Revoke object privileges
grant select, insert, update, delete on PAREBIDATA.LOG_RUN_CONFIG to parebidata,parebiopr,r_parebidata_dml;
-- Grant/Revoke object privileges
grant select, ALTER on PAREBIDATA.PRO_RUN_LOG_SE