CREATE TABLE UPDATERSERVICOFILI
(
  CDFILIAL        VARCHAR2(4) NOT NULL,
  MONITORAMENTO   VARCHAR2(4000) NULL,
  NRORG           NUMBER DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
  DTINCLUSAO      DATE DEFAULT SYSDATE,
  DTULTATU        DATE DEFAULT SYSDATE,
  NRORGINCLUSAO   NUMBER DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NULL,
  NRORGULTATU     NUMBER DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NULL,
  
  CONSTRAINT FK_UPDATERSERVICOFILI FOREIGN KEY (CDFILIAL) REFERENCES FILIAL (CDFILIAL)
);

INSERT INTO UPDATERSERVICOFILI (CDFILIAL)
SELECT CDFILIAL FROM FILIAL;