7 Replies Latest reply: Jan 10, 2013 10:43 AM by sb92075 RSS

    broken conection

    938302
      Hi Team,

      I have DB 9.2.0.7 ON uNIX

      I executed a delete.

      delete from FACT_VENTAS_DIA where ID_FECHA between to_date('28/12/2007','DD/MM/YYYY') AND TO_DATE('31/01/2008','DD/MM/YYYY');

      The conection was broken

      When, I executed " delete from FACT_VENTAS_DIA where ID_FECHA between to_date('28/12/2007','DD/MM/YYYY') AND TO_DATE('31/01/2008','DD/MM/YYYY');" again

      the process does not end

      Regards,
        • 1. Re: broken conection
          sb92075
          935299 wrote:
          Hi Team,

          I have DB 9.2.0.7 ON uNIX

          I executed a delete.

          delete from FACT_VENTAS_DIA where ID_FECHA between to_date('28/12/2007','DD/MM/YYYY') AND TO_DATE('31/01/2008','DD/MM/YYYY');

          The conection was broken

          When, I executed " delete from FACT_VENTAS_DIA where ID_FECHA between to_date('28/12/2007','DD/MM/YYYY') AND TO_DATE('31/01/2008','DD/MM/YYYY');" again

          the process does not end

          Regards,
          So what do you expect or desire from us?
          • 2. Re: broken conection
            938302
            Hi,

            I need to identify if the broken caused any problems in the table

            Thanks, Because I can't delete the registers

            Regards,
            • 3. Re: broken conection
              sb92075
              935299 wrote:
              Hi,

              I need to identify if the broken caused any problems in the table

              Thanks, Because I can't delete the registers

              Regards,
              Realize that we do not know what was in the table before you started
              & don't know what is in the table now.
              So why do you expect us to know if you have a problem or not?

              if a problem existed, how would you recognize it?
              • 4. Re: broken conection
                938302
                I am executing a delete. after 5 hours. this doesn't end
                • 5. Re: broken conection
                  sb92075
                  935299 wrote:
                  I am executing a delete. after 5 hours. this doesn't end
                  Above is an observation & so is below.
                  The Sun rose in the East this morning.

                  In order to gain some visibility regarding what was or was not actually occurring inside the DB,
                  consider doing as below prior to starting the DELETE again.

                  ALTER SESSION SET SQL_TRACE=TRUE;
                  • 6. Re: broken conection
                    938302
                    Hi,

                    I am deleting 3000000 registers.. this process is taking 5 hours and not end}

                    Do you have any comment?
                    Regards,
                    • 7. Re: broken conection
                      sb92075
                      935299 wrote:
                      Hi,

                      I am deleting 3000000 registers.. this process is taking 5 hours and not end}

                      Do you have any comment?
                      Regards,
                      you have a mystery & we have no clues.