spool DatosCodConsParcial.log set Define "!" set feedback off set define off prompt Deleting TCONSTRAINTSRESULTADO... delete from tConstraintsResultado where constraintname='FKIDITIPCORRESP'; delete from tConstraintsResultado where constraintname='FKPERCTADIR'; delete from tConstraintsResultado where constraintname='FKPERCTADIRNUMDIR'; delete from tConstraintsResultado where constraintname='FKPERCTADIRTIPCORRESP'; delete from tConstraintsResultado where constraintname='FKTIPCORRESPID'; delete from tConstraintsResultado where constraintname='IPKCTAPERDIR'; delete from tConstraintsResultado where constraintname='IPKTIPCORRESP'; delete from tConstraintsResultado where constraintname='IPKTIPCORRESPID'; prompt Deleting TCONSTRAINTSRESULTADOID... delete from tConstraintsResultadoId where constraintname='FKIDITIPCORRESP'; delete from tConstraintsResultadoId where constraintname='FKPERCTADIR'; delete from tConstraintsResultadoId where constraintname='FKPERCTADIRNUMDIR'; delete from tConstraintsResultadoId where constraintname='FKPERCTADIRTIPCORRESP'; delete from tConstraintsResultadoId where constraintname='FKTIPCORRESPID'; delete from tConstraintsResultadoId where constraintname='IPKCTAPERDIR'; delete from tConstraintsResultadoId where constraintname='IPKTIPCORRESP'; delete from tConstraintsResultadoId where constraintname='IPKTIPCORRESPID'; prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultadoId values('FKIDITIPCORRESP','2291','505348'); insert into tConstraintsResultadoId values('FKPERCTADIR','2291','505349'); insert into tConstraintsResultadoId values('FKPERCTADIRNUMDIR','2291','505350'); insert into tConstraintsResultadoId values('FKPERCTADIRTIPCORRESP','2291','505351'); insert into tConstraintsResultadoId values('FKTIPCORRESPID','2291','505352'); insert into tConstraintsResultadoId values('IPKCTAPERDIR','1','505353'); insert into tConstraintsResultadoId values('IPKTIPCORRESP','1','505354'); insert into tConstraintsResultadoId values('IPKTIPCORRESPID','1','505355'); prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultado values('ES','FKIDITIPCORRESP',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 TTIPOSCORRESPONDENCIA EN TIDIOMASID'); insert into tConstraintsResultado values('ES','FKPERCTADIR',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 TCUENTASPERSONADIRECCIONES EN TCUENTASPERSONAID'); insert into tConstraintsResultado values('ES','FKPERCTADIRNUMDIR',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 TCUENTASPERSONADIRECCIONES EN TPERSONADIRECCIONESID'); insert into tConstraintsResultado values('ES','FKPERCTADIRTIPCORRESP',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 TCUENTASPERSONADIRECCIONES EN TTIPOSCORRESPONDENCIAID'); insert into tConstraintsResultado values('ES','FKTIPCORRESPID',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 TTIPOSCORRESPONDENCIA EN TTIPOSCORRESPONDENCIAID'); insert into tConstraintsResultado values('ES','IPKCTAPERDIR',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 TCUENTASPERSONADIRECCIONES'); insert into tConstraintsResultado values('ES','IPKTIPCORRESP',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 TTIPOSCORRESPONDENCIA'); insert into tConstraintsResultado values('ES','IPKTIPCORRESPID',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 TTIPOSCORRESPONDENCIAID'); commit; set Define "&" set feedback on prompt Done. spool off