This discussion is archived
7 Replies Latest reply: Jan 10, 2013 8:43 AM by sb92075 RSS

broken conection

938302 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    I am executing a delete. after 5 hours. this doesn't end
  • 5. Re: broken conection
    sb92075 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points