

CREATE TABLE DAV_DAVIVIENDA_LOG
(
  N_ID                  NUMBER                  NOT NULL,
  N_ID_DAVIVIENDA_TRAN  NUMBER                  NOT NULL,
  D_FECHA               DATE                    NOT NULL,
  C_REQ_RES             VARCHAR2(2000 BYTE)     NOT NULL,
  C_ESTADO              VARCHAR2(30 BYTE)       NOT NULL,
  C_USUARIO             VARCHAR2(50 BYTE),
  C_JORNADA             VARCHAR2(50 BYTE)
)
TABLESPACE WMS_TAB
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


ALTER TABLE DAV_DAVIVIENDA_LOG ADD (
  PRIMARY KEY
 (N_ID)
    USING INDEX 
    TABLESPACE WMS_TAB
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          64K
                NEXT             1M
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
               ));
