This content has been marked as final. Show 7 replies
935299 wrote:So what do you expect or desire from us?
I have DB 220.127.116.11 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
935299 wrote:Realize that we do not know what was in the table before you started
I need to identify if the broken caused any problems in the table
Thanks, Because I can't delete the registers
& 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?
935299 wrote:Above is an observation & so is below.
I am executing a delete. after 5 hours. this doesn't end
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;