Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: ORA-03113 (end of file communication channel)

Re: ORA-03113 (end of file communication channel)

From: rr <raineyr_at_look.ca>
Date: Fri, 26 Jan 2001 20:01:25 GMT
Message-ID: <3A71F407.9289DD48@look.ca>

It is possible you have too many records to delete at once. Suppose the table has 300000 records. You could try delete from ... where primary_key < 1000; If that works, try deleting the records in chunks, committing each chunk as you are happy with it.
rachel

Emmanuel Laurent wrote:

> Hi. I'm using an oracle 8.0.5 on a HP-UX machine.
> I have an error ORA-03113 (end of file communication channel) in recording
> suppression on some of my tables.
>
> Ex : DELETE FROM MYTABLE WHERE MYCODE = 'XXX'
>
> Could anybody help me?
>
> Thank you beforehand
  Received on Fri Jan 26 2001 - 14:01:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US