Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> end-of-file on communication channel ERROR ! --Please Help
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