ORA-03113: end-of-file on communication channel when trying to insert rows!
Hi everybody,
I'm disconnected from oracle when I'm trying to insert rows to a specific table. I'm using Oracle 9iR2 on Windows XP.
This is an example that what is happening:
SQL> connect myuser/pass@myservice
Connected.
SQL> select * from sustancia_tempo;
ID_ACTIVO ID_SUSTANCIA ID_ESTMATERIA ID_UNIDMEDIDA CANTIDAD NUM_ONU K_FUG_FE K_NUM_FUGA K_INSTA
---------- ------------ ------------- ------------- ---------- ---------- -------- ---------- ------
4 2 2 2 23 11 10/03/98 104 GBTJSAPR 221 2
4 2 2 2 12 22 10/03/98 104 GBTJSAPR 221 3
4 1 1 1 0 222222 10/03/98 104 GBTJSAPR 221 1
4 2 2 2 23 23 10/03/98 104 GBTJSAPR 221 4
SQL> delete from sustancia_tempo;
4 rows deleted.
SQL> INSERT INTO SUSTANCIA_TEMPO ( id_activo, k_fug_fecha, k_num_fuga, k_instalacion, k_distrito
, cantidad, id_estmateria, id_sustancia, id_unidmedida, num_onu )
2 VALUES ( 1, to_date ('01-01-2003', 'dd-mm-yyyy'), 1, '1', '1', 10, 1, 1, 1, 'xx' )
3 /
INSERT INTO SUSTANCIA_TEMPO ( id_activo, k_fug_fecha, k_num_fuga, k_instalacion, k_distrito, can
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Any help to solve this question will be very appreciated.
Thanks in advance.
Regards.
Re: ORA-03113: end-of-file on communication channel when trying to insert rows!
Quote:
Originally posted by Turin
ORA-03113: end-of-file on communication channel
this usually means that you have ora-600 or ora-7445 in your alert log and user dump.