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

Home -> Community -> Usenet -> c.d.o.server -> end-of-file on communication channel ERROR ! --Please Help

end-of-file on communication channel ERROR ! --Please Help

From: <orib_at_galileo.co.il>
Date: Mon, 20 Dec 1999 09:33:19 +0200
Message-ID: <385DDBBE.655D128B@galileo.co.il>


Hi All.
I'm running Oracle DB ver 8.1.5 on sun solaris 2.6 for about a month, Yesterday I tried to run an SQL query to delete some records (about 10,000).
The query took a long time (although it was a simple one) , and after a few minutes it reported :
SQL> @del1.sql
delete from BASIC1 where opname like 'DISC' *
ERROR at line 1:
ORA-03113: end-of-file on communication channel

Later on I tried to run another deleting query which is almost as the first one
and got the following error:

ORA-01562: failed to extend rollback segment number 1 ORA-01628: max # extents (121) reached for rollback segment RBS1PRO

How can I solve this problem ?
Is it the same problem in both cases ?

Thanks a lot .

Ori Received on Mon Dec 20 1999 - 01:33:19 CST

Original text of this message

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