( ora - 00955 )

[tamerali]

hi , i have this problem , Failed to Create Feature class in ArcCatalog as versioned (DBMS Error ORA-00955)
I am trying to Create Feature Class through Spatial Database Connection as versioned.(ArcSDE 9.3)

While i am trying to do this getting the below error.
failed to register as versioned , table already exists ( ora - 00955 ) name is already used by an existing object

[VinceAngelo]

Did you create tables or indexes named A22 or D13 (anything matching [ASDF]n, where
n is any number)? If so, that's probably the cause.  Your database error log will likely have
more information.

Even when I'm populating trivial tables to test instances with large numbers of tables, I name
them with at least 8-15 characters (TABLE0001, FEATURECLASS0007).  Long names are far more
likely to be self-documenting (the same goes for columns).

- V

[tamerali]

thank you for your answer , but plz can u explain more about this ?

[VinceAngelo]

The documentation does a much better job of describing how ArcSDE is implemented
than I ever could.  Suffice it to say that versioing a table creates supporting tables
and indexes, and the error indicates that a naming conflict exists on one of these
supporting tables/indexes.  If you review the ArcSDE logs in $SDEHOME/etc and/or
the Oracle alert log, you should be able to determine exactly what has gone wrong.

- V

[tamerali]

thank you very much , i delete the old ( A , D ) tables , then all thing is okay .

[VinceAngelo]

It's premature to call everything "okay" until you can discover:
1) Why the old tables existed outside the maintenance of ArcSDE
2) What other tables might be similarly orphaned.
3) If any data of value has been lost in this process

- V