Oracle ODP.NET BulkCopy to temporary table issue

odp.net ora-03113 oracle sqlbulkcopy

Question

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?

Thank you!

Accepted Answer

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.

Regards,
Rob.


Popular Answer

I've contacted Oracle about this. Apparently it's a bug, that was fixed in 11g. They're now trying to release a patch



Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why