ALTER TABLE PARAMESTGNRE 
   ADD IDFCPSEPIMP VARCHAR2(01) DEFAULT 'N' NOT NULL 
      CONSTRAINT CKC_IDFCPSEPIMP_PARAMESTGNRE CHECK(IDFCPSEPIMP IN ('S','N'))
/

ALTER TABLE GNRENF DROP CONSTRAINT CKC_GNRENF_IDTPGUIAPAG
/

ALTER TABLE GNRENF ADD CONSTRAINT CKC_GNRENF_IDTPGUIAPAG CHECK (IDTPGUIAPAG IN ('I','O','D','F','P'))
/ 