I'm trying to copy/paste a File Geodatabase into an Oracle SDE Instance running in Windows 7. There are 61 classes in the FGDB. When it hits about the 6th class I get the error:
Failed to paste <dataset>
Underlying DBMS error
From there I'm trying to find out what kind of error was encountered. I've looked in the Windows Event Viewer but can't find anything there. Is there another location where I could find more details about the error?
Copying and pasting a FGDB into SDE seems like a lot to ask. My suggestion is to import your feature classes from the FGDB into SDE with the import multiple feature classes utility.
You're using direct connect to establish the connection to your enterprise geodatabase, right? We need to capture the Oracle error code before knowing what the issue might be according to your database.
What does the following log file say?
What do your Oracle database Alert log files show?
Typically located at C:\oracle\diag\rdbms\<db_name>\<db_name>\alert\log.xml
Typically located at C:\oracle\diag\rdbms\<db_name>\<db_name>\trace\alert_<db_name>.log
Note: Replace <db_name> with the name of your Oracle database SID.