Select to view content in your preferred language

Data Load Issue

4848
10
04-08-2013 08:02 PM
User35489
Frequent Contributor
Dear Admins,

We installed new server with RHEL 6, Oracle 11.2.0.3.0, ArcSDE 10.1. Our old server is on RHEL 5, Oracle 10.2.0.3, ArcSDE 9.3.
When i tried to import the feature class to new server or copy the feature class from old to new one, migrate storage etc. I faced errors given below. I donot know whether it is because of the change of Geometry type, as in 9.3 we used to have SDEBINARY and in 10.1 we have ST_BINARY.
Please look into this issue.


1. Error 000210: Cannot create output Database Connections\ ...
2. Failed to paste [FeatureClassName]
    Underlying DBMS error [ORA-00604: error occurred at recursive SQL level 1
    ORA- 04063 ...
    ORA- 06508 ...
3.  ERROR 000955: Error encountered migrating the database storage ...




Thanks
Abdullah
0 Kudos
10 Replies
VinceAngelo
Esri Esteemed Contributor
If the "reinstall from scratch" approach worked, you should probably put the response
that suggested it as the solution.  This isn't an issue about points -- the caveat to the
dangers of dropping the SDE user while ST_GEOMETRY layers exist is very important
(doing so will corrupt your Oracle instance irrevocably).

- V
0 Kudos