I'm using BulkCopy method from ODP.NET to insert a DataTable to a temporary table. If the temporary table is simple (no triggers or indexes) it works, fine, but as soon as I create an index or trigger, i get the "End-of-file on communication channel" error at BulkCopy.WriteToServer() method. Any idea how could i fix this?
In case of an ORA-03113: end-of-file on communication channel, the server process dedicated to your session died because of a bug or error. The client process detects that the server process is missing and raises the ORA-03113. The server process has written its error message to the alert file. Check this file on the server to find out what went wrong. You may have to ask your DBA to do this for you.
I've contacted Oracle about this. Apparently it's a bug, that was fixed in 11g. They're now trying to release a patch