ORA-03113 End-of-Communication when doing large inserts via PL/SQL

[siva2102]

I have a Oracle9i (9.2) database running on Windows 2000. I am using a PL/SQL script to read a variable length text file and insert large number of records to the database. I get the message PL/SQL procedure completed but no records have been inserted. At the database end, I get the message 'ORA-03113 End-of-Communication'.

Would appreciate if someone could help me to start troubleshooting this problem.

Thanks.

[Vipassana]

expose the script, lets get a taste of whats happening.

[Dilippatel]

There is possiblilty of missing communication link ( Network problem ).

You can set some parameters to alive the connection between client and server or tune the Net8 and at the OS level.

[sonofsita]

If you are on Oracle 9.2.0.5 and
are trying to use dbms_metadata you may get ORA-03113. If you are using ansi joins you may get ORA-03113.If you are using trying to insert long data type converted using to_lob you may get ORA-03113.
These are my experiences. Out of which Oracle has provided me one off patch for ANSI joins and for others, I was told fixed in 10G.Search for a patch provided by Oracle depending upon the case you fit in.