CREATE TABLE TAB_BACKUP_SOURCE
(
  ID           NUMBER,
  OWNER        VARCHAR2(32 BYTE),
  OBJ_NAME     VARCHAR2(32 BYTE),
  OBJ_TYPE     VARCHAR2(32 BYTE),
  LOGTIME      DATE DEFAULT SYSDATE,
  WHO          VARCHAR2(32 BYTE),
  IP           VARCHAR2(23 BYTE),
  SOURCE_CODE  CLOB
)
TABLESPACE DATA_TBS_4MB
NOLOGGING 
LOB (SOURCE_CODE) STORE AS 
      ( TABLESPACE  LOB_TBS_1MB 
        ENABLE      STORAGE IN ROW
        CHUNK       16384
        PCTVERSION  10
        NOCACHE
      )
NOCACHE
NOPARALLEL
MONITORING
/


CREATE INDEX INDX_TB_BACKUP_SOURCE ON TAB_BACKUP_SOURCE
(OWNER, OBJ_TYPE, OBJ_NAME)
NOLOGGING
TABLESPACE INDX_TBS_500KB
/

CREATE SEQUENCE SEQ_TAB_BACKUP_SOURCE_ID
  START WITH 1
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 3
  NOORDER;
	

CREATE OR REPLACE TRIGGER TRG_BACKUP_SOURCE_ID
BEFORE INSERT ON TAB_BACKUP_SOURCE
FOR EACH ROW
BEGIN
  SELECT SEQ_TAB_BACKUP_SOURCE_ID.NEXTVAL
  INTO :NEW.id
  FROM dual;
END;
/