Atribute update in SDE Feature Class ora-02005: implicit (-1)

12-14-2011 10:23 PM
New Contributor II
I am getting an error while editing a feature class details in Arcmap.

attribute update: An unexpected failure occured.
Underlying dbms error  [ora-02005: implicit (-1) length not valid for this bind or define datatype]

I am using ArcGIS/ArcSDE 10 with Oracle

Though its database related error, the reason for posting here that i might get pointers to direct from SDE point of view.

0 Kudos
1 Reply
Esri Esteemed Contributor
That's an unusual error.  Did you change the structure of the table after it was registered
with ArcSDE?

You *REALLY* shouldn't create or edit any table as the SDE user.  SDE should be treated as
a privileged account like SYSTEM or MDSYS, and only used for ArcSDE administration.  Best
practice is to create one or more tablespaces to contain your data, and one or more data
management users to own and manipulate the data.  You are infinitely more likely to damage
your instance when you use the SDE user for non-administrative purposes.

- V
0 Kudos