spool DatosCodConsParcial.log set Define "!" set feedback off set define off prompt Deleting TCONSTRAINTSRESULTADO... delete from tConstraintsResultado where constraintname='CKESVENCIMIENTOFUTURO'; delete from tConstraintsResultado where constraintname='FKRANCLASESTOPE'; delete from tConstraintsResultado where constraintname='FKTRASPSTATACT'; delete from tConstraintsResultado where constraintname='FKTRASPSTATPAS'; delete from tConstraintsResultado where constraintname='IPKTRASPSTAT'; prompt Deleting TCONSTRAINTSRESULTADOID... delete from tConstraintsResultadoId where constraintname='CKESVENCIMIENTOFUTURO'; delete from tConstraintsResultadoId where constraintname='FKRANCLASESTOPE'; delete from tConstraintsResultadoId where constraintname='FKTRASPSTATACT'; delete from tConstraintsResultadoId where constraintname='FKTRASPSTATPAS'; delete from tConstraintsResultadoId where constraintname='IPKTRASPSTAT'; prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultadoId values('CKESVENCIMIENTOFUTURO','2290','505302'); insert into tConstraintsResultadoId values('FKRANCLASESTOPE','2291','505306'); insert into tConstraintsResultadoId values('FKTRASPSTATACT','2291','505303'); insert into tConstraintsResultadoId values('FKTRASPSTATPAS','2291','505304'); insert into tConstraintsResultadoId values('IPKTRASPSTAT','1','505305'); prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultado values('ES','CKESVENCIMIENTOFUTURO',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'FUERA DE LOS VALORES PERMITIDOS PARA TTRASPASOSESTATUS.'); insert into tConstraintsResultado values('ES','FKRANCLASESTOPE',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'NO EXISTE REFERENCIA DE TRANGOSCLASIFICACION EN TESTADOOPERACIONID'); insert into tConstraintsResultado values('ES','FKTRASPSTATACT',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'NO EXISTE REFERENCIA DE TTRASPASOSESTATUS EN TESTATUSCUENTAID'); insert into tConstraintsResultado values('ES','FKTRASPSTATPAS',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'NO EXISTE REFERENCIA DE TTRASPASOSESTATUS EN TESTATUSCUENTAID'); insert into tConstraintsResultado values('ES','IPKTRASPSTAT',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'REGISTRO DUPLICADO CLAVE PRINCIPAL DE TTRASPASOSESTATUS'); commit; set Define "&" set feedback on prompt Done. spool off