ALTER TABLE PARASUPRI ADD TXAVISOLEGALEMAIL CLOB NULL  
/ 

CREATE TABLE INFORMATIVOECOMMERCE
(
   DSTITULOINF  	VARCHAR2(100) 		NOT NULL,
   TXCONTEUDOINF 	CLOB 				NOT NULL,
   IDNOTIFICACAO 	VARCHAR2(1) 		NULL, 
   DTEXPIRAINFO  	DATE 				NOT NULL,
   DTINFORMARIVI   	DATE 				NOT NULL,
   NRORG 		   	NUMBER DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
   IDATIVO        	VARCHAR2(1) DEFAULT 'S' NOT NULL,
      CONSTRAINT CKC_IDATIVO_INFOECOMMERCE CHECK (IDATIVO IN ('S','N')),
   DTINCLUSAO     	DATE NULL,
   DTULTATU       	DATE  NULL,
   NRORGINCLUSAO  	NUMBER  DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NULL,
   CDOPERINCLUSAO 	VARCHAR2(12) DEFAULT '1' NULL,
   NRORGULTATU    	NUMBER DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NULL,
   CDOPERULTATU 	VARCHAR2(12) DEFAULT '1'
) 