大量数据插入oracle连接中断的问题

这几天在做大数据量入库的存储实验，在大量数据执行拟造过程中数据库出现了问题无法继续执行，初步推断是因为大数据量插入导致数据库连接断开，问题记录如下：

原文地址：http://gis.stackexchange.com/questions/108297/oracle-error-when-copying-massive-feature-dataset

Oracle error when copying massive feature dataset

In ArcCatalog 10.1, when copying a feature dataset with roughly 3 million objects as well as a few thousand tables and relationship classes, my team is running into an 'Underlying DBMS error [ORA-03114: not connected to ORACLE][SDE.DEFAULT]' message 9 times out of 10... I'm hoping someone has run into a similar issue. We are literally copying the feature dataset from one connection file and pasting it into another connection file/environment. This works fine with smaller sets of data. However, for this bigger dataset transfer, we are running into this problem - the process copies all objects but fails in the late stages (I think when it is copying tables). This is killing us, since the process takes about 20 hours and then bombs! X( I also get a Paste Failed Message each time: 'Failed to paste GEODATA.NA_US_SOIL_MUPOLYGON_2013 Invalid function arguments Underlying DBMS error [SDE.GDB_ITEMS] Underlying DBMS error [ORA-03114: not connected to ORACLE][GEODATA.NA_US_SOIL_MUPOLYGON_x] Underlying DBMS [ORA-03114: not connected to ORACLE] Underlying DBMS error [ORA-03113: end-of-file on communication channel Process ID: 7804 Session ID: 205 Serial number: 52647][GEODATA.NA_US_SOIL_MUPOLYGON_x] We've discussed this issue at length with Oracle DB team here and cannot seem to find any issue in Oracle logs. Our OS is Windows Server 2008 Std64 bit SP2, ArcSDE 10.1 SP1, and the server is a DellR710. Has anyone encountered a similar error? We're at our wits' end here. Thanks for any suggestions!