spool DatosCodConsParcial.log set Define "!" set feedback off set define off prompt Deleting TCONSTRAINTSRESULTADO... delete from tConstraintsResultado where constraintname='FKRESIDCODCON'; delete from tConstraintsResultado where constraintname='IPKRESIDCODCON'; prompt Deleting TCONSTRAINTSRESULTADOID... delete from tConstraintsResultadoId where constraintname='FKRESIDCODCON'; delete from tConstraintsResultadoId where constraintname='IPKRESIDCODCON'; prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultadoId values('FKRESIDCODCON','2291','505345'); insert into tConstraintsResultadoId values('IPKRESIDCODCON','1','505346'); prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultado values('ES','FKRESIDCODCON',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 TRESIDENCIACODIGOCONTABLE EN TRESIDENCIAID'); insert into tConstraintsResultado values('ES','IPKRESIDCODCON',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 TRESIDENCIACODIGOCONTABLE'); commit; set Define "&" set feedback on prompt Done. spool off