Oracle通用日志表设计

-- Create sequence
create sequence SEQ_COMMON_LOG
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

 

-- Create table
create table TU_COMMON_LOG
(
  COL_SEQUENCE           NUMBER(20) not null,
  COL_DATE               DATE default sysdate not null,
  COL_SYSTEM             VARCHAR2(100),
  COL_PACKAGE            VARCHAR2(100),
  COL_FUNCTION_PROCEDURE VARCHAR2(100),
  COL_MESSAGE            VARCHAR2(4000),
  COL_IS_EXCEPTION       VARCHAR2(1) default 'N'
)
tablespace USERS
  pctfree 10
  initrans 1