Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: ORA-03113 (end of file communication channel)
Decrease the number of processes in your initSID.ora file or increase semaphores MNI value in the kernel
"Emmanuel Laurent" <e.laurent_at_publisuisse-fr.com> wrote in message
news:953pig$tvi$1_at_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:24:29 CST