I am working with an Oracle DBA to copy/paste all our production data to a new Oracle-SDE database with SDO_GEOMETRY and ArcSDE 10 and we are trying to use the Geodatabase Designer 2, added to an ArcCatalog 10 client, to do this. In the past, working with ArcSDE 9 and v.9 client this has worked. But now it doesn't. We have followed the recommendations in replies 4,6,and 7. Butat the very start of the process, trying to copy the first dataset which is our GISADM.200 Annual_2004_Roll, we are getting this error:
Failed to paste GISADM.Annual_2004_Roll
Underlying DBMS error [ORA-0001:unique constraint (SDE.R2_SDE_ROWID_UK) violated][SDE_GDB_Items]
The index passed was not within the valid range
The index passed was not within the valid range
....
Does anyone have an idea what is causing this?
Doug Olcott, GIS Software Engineer
Santa Clara County ISD