spool DatosCodConsParcial.log set Define "!" set feedback off set define off prompt Deleting TCONSTRAINTSRESULTADO... delete from tConstraintsResultado where constraintname='FKAT10RUBID'; delete from tConstraintsResultado where constraintname='FKCONSEXTCIALIC'; delete from tConstraintsResultado where constraintname='FKCTAINT'; delete from tConstraintsResultado where constraintname='FKCTAINTMONOFI'; delete from tConstraintsResultado where constraintname='FKIDIAT10RUB'; delete from tConstraintsResultado where constraintname='FKIDITIPPLANREP'; delete from tConstraintsResultado where constraintname='FKREPDATTIPPLANREP'; delete from tConstraintsResultado where constraintname='FKSALCONDIACODCON'; delete from tConstraintsResultado where constraintname='FKSALCONDIASUC'; delete from tConstraintsResultado where constraintname='FKSALCONDIATIPSALCAT'; delete from tConstraintsResultado where constraintname='FKSALMONCTACTACON'; delete from tConstraintsResultado where constraintname='FKSALMONCTASUBC'; delete from tConstraintsResultado where constraintname='FKSALMONCTASUCOFI'; delete from tConstraintsResultado where constraintname='FKSALMONCTATIPSALC'; delete from tConstraintsResultado where constraintname='FKSALMONOFICTACON'; delete from tConstraintsResultado where constraintname='FKSALMONOFISUBC'; delete from tConstraintsResultado where constraintname='FKSALMONOFISUCOFI'; delete from tConstraintsResultado where constraintname='FKSALMONOFITIPSALC'; delete from tConstraintsResultado where constraintname='FKTIPPLANREPID'; delete from tConstraintsResultado where constraintname='FKVAREXTCIALIC'; delete from tConstraintsResultado where constraintname='IPKAT10RUBRO'; delete from tConstraintsResultado where constraintname='IPKAT10RUBROID'; delete from tConstraintsResultado where constraintname='IPKCONSEXTERNA'; delete from tConstraintsResultado where constraintname='IPKCTAINTERES'; delete from tConstraintsResultado where constraintname='IPKSALDOCONDIA'; delete from tConstraintsResultado where constraintname='IPKSALMONCTADIA'; delete from tConstraintsResultado where constraintname='IPKSALOFICTADIA'; delete from tConstraintsResultado where constraintname='IPKTIPPLANREP'; delete from tConstraintsResultado where constraintname='IPKTIPPLANREPID'; delete from tConstraintsResultado where constraintname='IPKVAREXTERNA'; prompt Deleting TCONSTRAINTSRESULTADOID... delete from tConstraintsResultadoId where constraintname='FKAT10RUBID'; delete from tConstraintsResultadoId where constraintname='FKCONSEXTCIALIC'; delete from tConstraintsResultadoId where constraintname='FKCTAINT'; delete from tConstraintsResultadoId where constraintname='FKCTAINTMONOFI'; delete from tConstraintsResultadoId where constraintname='FKIDIAT10RUB'; delete from tConstraintsResultadoId where constraintname='FKIDITIPPLANREP'; delete from tConstraintsResultadoId where constraintname='FKREPDATTIPPLANREP'; delete from tConstraintsResultadoId where constraintname='FKSALCONDIACODCON'; delete from tConstraintsResultadoId where constraintname='FKSALCONDIASUC'; delete from tConstraintsResultadoId where constraintname='FKSALCONDIATIPSALCAT'; delete from tConstraintsResultadoId where constraintname='FKSALMONCTACTACON'; delete from tConstraintsResultadoId where constraintname='FKSALMONCTASUBC'; delete from tConstraintsResultadoId where constraintname='FKSALMONCTASUCOFI'; delete from tConstraintsResultadoId where constraintname='FKSALMONCTATIPSALC'; delete from tConstraintsResultadoId where constraintname='FKSALMONOFICTACON'; delete from tConstraintsResultadoId where constraintname='FKSALMONOFISUBC'; delete from tConstraintsResultadoId where constraintname='FKSALMONOFISUCOFI'; delete from tConstraintsResultadoId where constraintname='FKSALMONOFITIPSALC'; delete from tConstraintsResultadoId where constraintname='FKTIPPLANREPID'; delete from tConstraintsResultadoId where constraintname='FKVAREXTCIALIC'; delete from tConstraintsResultadoId where constraintname='IPKAT10RUBRO'; delete from tConstraintsResultadoId where constraintname='IPKAT10RUBROID'; delete from tConstraintsResultadoId where constraintname='IPKCONSEXTERNA'; delete from tConstraintsResultadoId where constraintname='IPKCTAINTERES'; delete from tConstraintsResultadoId where constraintname='IPKSALDOCONDIA'; delete from tConstraintsResultadoId where constraintname='IPKSALMONCTADIA'; delete from tConstraintsResultadoId where constraintname='IPKSALOFICTADIA'; delete from tConstraintsResultadoId where constraintname='IPKTIPPLANREP'; delete from tConstraintsResultadoId where constraintname='IPKTIPPLANREPID'; delete from tConstraintsResultadoId where constraintname='IPKVAREXTERNA'; prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultadoId values('FKAT10RUBID','2291','505424'); insert into tConstraintsResultadoId values('FKCONSEXTCIALIC','2291','505425'); insert into tConstraintsResultadoId values('FKCTAINT','2291','505426'); insert into tConstraintsResultadoId values('FKCTAINTMONOFI','2291','505427'); insert into tConstraintsResultadoId values('FKIDIAT10RUB','2291','505428'); insert into tConstraintsResultadoId values('FKIDITIPPLANREP','2291','505430'); insert into tConstraintsResultadoId values('FKREPDATTIPPLANREP','2291','505431'); insert into tConstraintsResultadoId values('FKSALCONDIACODCON','2291','505433'); insert into tConstraintsResultadoId values('FKSALCONDIASUC','2291','505434'); insert into tConstraintsResultadoId values('FKSALCONDIATIPSALCAT','2291','505435'); insert into tConstraintsResultadoId values('FKSALMONCTACTACON','2291','505436'); insert into tConstraintsResultadoId values('FKSALMONCTASUBC','2291','505437'); insert into tConstraintsResultadoId values('FKSALMONCTASUCOFI','2291','505438'); insert into tConstraintsResultadoId values('FKSALMONCTATIPSALC','2291','505439'); insert into tConstraintsResultadoId values('FKSALMONOFICTACON','2291','505440'); insert into tConstraintsResultadoId values('FKSALMONOFISUBC','2291','505441'); insert into tConstraintsResultadoId values('FKSALMONOFISUCOFI','2291','505442'); insert into tConstraintsResultadoId values('FKSALMONOFITIPSALC','2291','505443'); insert into tConstraintsResultadoId values('FKTIPPLANREPID','2291','505444'); insert into tConstraintsResultadoId values('FKVAREXTCIALIC','2291','505446'); insert into tConstraintsResultadoId values('IPKAT10RUBRO','1','505447'); insert into tConstraintsResultadoId values('IPKAT10RUBROID','1','505448'); insert into tConstraintsResultadoId values('IPKCONSEXTERNA','1','505449'); insert into tConstraintsResultadoId values('IPKCTAINTERES','1','505450'); insert into tConstraintsResultadoId values('IPKSALDOCONDIA','1','505452'); insert into tConstraintsResultadoId values('IPKSALMONCTADIA','1','505453'); insert into tConstraintsResultadoId values('IPKSALOFICTADIA','1','505454'); insert into tConstraintsResultadoId values('IPKTIPPLANREP','1','505455'); insert into tConstraintsResultadoId values('IPKTIPPLANREPID','1','505456'); insert into tConstraintsResultadoId values('IPKVAREXTERNA','1','505457'); prompt Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKAT10RUBID',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 TAT10RUBROS EN TAT10RUBROSID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKCONSEXTCIALIC',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 TCONSULTASEXTERNAS EN TCOMPANIASLICENCIADASID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKCTAINT',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 TCUENTAINTERESDIARIO EN TCUENTAID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKCTAINTMONOFI',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 TCUENTAINTERESDIARIO EN TMONEDASID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKIDIAT10RUB',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 TAT10RUBROS EN TIDIOMASID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKIDITIPPLANREP',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 TTIPOSPLANTILLAREPORTES EN TIDIOMASID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKREPDATTIPPLANREP',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 TREPORTEDATOSDIARIO EN TTIPOSPLANTILLAREPORTESID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKSALCONDIACODCON',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 TSALDOSCONTABLESDIARIO EN TCUENTACONTABLEID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKSALCONDIASUC',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 TSALDOSCONTABLESDIARIO EN TSUCURSALESID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKSALCONDIATIPSALCAT',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 TSALDOSCONTABLESDIARIO EN TTIPOSSALDOCATEGORIAID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKSALMONCTACTACON',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 TSALDOSMONEDACUENTADIARIO EN TCUENTACONTABLEID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKSALMONCTASUBC',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 TSALDOSMONEDACUENTADIARIO EN TSUBCUENTASID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKSALMONCTASUCOFI',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 TSALDOSMONEDACUENTADIARIO EN TOFICINASSUCURSAL'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKSALMONCTATIPSALC',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 TSALDOSMONEDACUENTADIARIO EN TTIPOSSALDOCATEGORIAID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKSALMONOFICTACON',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 TSALDOSMONEDAOFICIALDIARIO EN TCUENTACONTABLEID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKSALMONOFISUBC',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 TSALDOSMONEDAOFICIALDIARIO EN TSUBCUENTASID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKSALMONOFISUCOFI',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 TSALDOSMONEDAOFICIALDIARIO EN TOFICINASSUCURSAL'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKSALMONOFITIPSALC',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 TSALDOSMONEDAOFICIALDIARIO EN TTIPOSSALDOCATEGORIAID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKTIPPLANREPID',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 TTIPOSPLANTILLAREPORTES EN TTIPOSPLANTILLAREPORTESID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKVAREXTCIALIC',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 TVARIABLESEXTERNASDEFINICION EN TCOMPANIASLICENCIADASID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKAT10RUBRO',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 TAT10RUBROS'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKAT10RUBROID',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 TAT10RUBROSID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKCONSEXTERNA',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 TCONSULTASEXTERNAS'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKCTAINTERES',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 TCUENTAINTERESDIARIO'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKSALDOCONDIA',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 TSALDOSCONTABLESDIARIO'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKSALMONCTADIA',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 TSALDOSMONEDACUENTADIARIO'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKSALOFICTADIA',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 TSALDOSMONEDAOFICIALDIARIO'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKTIPPLANREP',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 TTIPOSPLANTILLAREPORTES'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKTIPPLANREPID',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 TTIPOSPLANTILLAREPORTESID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKVAREXTERNA',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 TVARIABLESEXTERNASDEFINICION'); commit; set Define "&" set feedback on prompt Done. spool off