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

From: Emmanuel Laurent <e.laurent_at_publisuisse-fr.com>
Date: Mon, 29 Jan 2001 14:08:02 +0100
Message-ID: <953pig$tvi$1@s1.read.news.oleane.net>

Thank you of your answer, but it does not answer my problem because MYCODE is my primary key and the number of record in the table is 10.

If you have other suggestions, do not hesitate. Thank you very much

Emmanuel

"rr" <raineyr_at_look.ca> wrote in message news:3A71F407.9289DD48_at_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 Mon Jan 29 2001 - 07:08:02 CST