-
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.
-
Have you looked into the Alert and User Dump logs to see what they
tell you ???
-
This table have some relationship / constraint by DBLINK ?
Last edited by marcio.68; 07-22-2003 at 02:24 PM.
Márcio de Souza Almeida
DBA Oracle / SQLServer / PostgreSQL
Rua Cupa, 139 Apto 85 A
Penha - São Paulo - SP
03640-000 - Brasil
http://www.directory.com.br
-
Re: ORA-03113: end-of-file on communication channel when trying to insert rows!
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.
Tomaž
"A common mistake that people make when trying to design something completely
foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
-
Originally posted by marcio.68
This table have some relationship / constraint by DBLINK ?
No such thing exists. You can't have RI constraint/relationship defined on the table that is accessed through DB link. Unless you coded that integrity constraint yourself wit a trigger(s), but then this is not what is usualy understand as referential integrity (declarative RI).
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
The table doesn't have any constraint/primary key.
I found a trigger on the table is the problem. So I changed the code encapsulling all of it (trigger + insert ) in a store procedure and it runs ok, but I don't know what is the problem with the trigger.
This is the code inside the trigger (before insert trigger):
SELECT COUNT(*)+1
INTO :NEW.ID_CONSEC
FROM SUSTANCIA_TEMPO;
Regards.
Last edited by Turin; 07-22-2003 at 06:24 PM.
-
You should look into Oracle sequences to provide you with a one-up counter unique ID. The count(*) method (whether in a stored proc or in a trigger itself) is going to get slower and slower as the table grows.
Tom Best
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|