Data Load Issue

[User35489]

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

[VinceAngelo]

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