topic Re: ( ora - 00955 ) in Data Management Questions https://community.esri.com/t5/data-management-questions/ora-00955/m-p/533099#M30178 <HTML><HEAD></HEAD><BODY><SPAN>Did you create tables or indexes named A22 or D13 (anything matching [ASDF]n, where</SPAN><BR /><SPAN> n is any number)? If so, that's probably the cause.&nbsp; Your database error log will likely have </SPAN><BR /><SPAN>more information.</SPAN><BR /><BR /><SPAN>Even when I'm populating trivial tables to test instances with large numbers of tables, I name</SPAN><BR /><SPAN>them with at least 8-15 characters (TABLE0001, FEATURECLASS0007).&nbsp; Long names are far more</SPAN><BR /><SPAN>likely to be self-documenting (the same goes for columns).</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Sat, 22 Sep 2012 11:55:11 GMT VinceAngelo 2012-09-22T11:55:11Z ( ora - 00955 ) https://community.esri.com/t5/data-management-questions/ora-00955/m-p/533098#M30177 <HTML><HEAD></HEAD><BODY><SPAN>hi , i have this problem , Failed to Create Feature class in ArcCatalog as versioned (DBMS Error ORA-00955)</SPAN><BR /><SPAN>I am trying to Create Feature Class through Spatial Database Connection as versioned.(ArcSDE 9.3) </SPAN><BR /><BR /><SPAN>While i am trying to do this getting the below error. </SPAN><BR /><SPAN>failed to register as versioned , table already exists ( ora - 00955 ) name is already used by an existing object</SPAN></BODY></HTML> Sat, 22 Sep 2012 05:15:27 GMT https://community.esri.com/t5/data-management-questions/ora-00955/m-p/533098#M30177 tamerali 2012-09-22T05:15:27Z Re: ( ora - 00955 ) https://community.esri.com/t5/data-management-questions/ora-00955/m-p/533099#M30178 <HTML><HEAD></HEAD><BODY><SPAN>Did you create tables or indexes named A22 or D13 (anything matching [ASDF]n, where</SPAN><BR /><SPAN> n is any number)? If so, that's probably the cause.&nbsp; Your database error log will likely have </SPAN><BR /><SPAN>more information.</SPAN><BR /><BR /><SPAN>Even when I'm populating trivial tables to test instances with large numbers of tables, I name</SPAN><BR /><SPAN>them with at least 8-15 characters (TABLE0001, FEATURECLASS0007).&nbsp; Long names are far more</SPAN><BR /><SPAN>likely to be self-documenting (the same goes for columns).</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Sat, 22 Sep 2012 11:55:11 GMT https://community.esri.com/t5/data-management-questions/ora-00955/m-p/533099#M30178 VinceAngelo 2012-09-22T11:55:11Z Re: ( ora - 00955 ) https://community.esri.com/t5/data-management-questions/ora-00955/m-p/533100#M30179 <HTML><HEAD></HEAD><BODY><SPAN>thank you for your answer , but plz can u explain more about this ?</SPAN></BODY></HTML> Sat, 22 Sep 2012 13:37:29 GMT https://community.esri.com/t5/data-management-questions/ora-00955/m-p/533100#M30179 tamerali 2012-09-22T13:37:29Z Re: ( ora - 00955 ) https://community.esri.com/t5/data-management-questions/ora-00955/m-p/533101#M30180 <HTML><HEAD></HEAD><BODY><SPAN>The documentation does a much better job of describing how ArcSDE is implemented</SPAN><BR /><SPAN>than I ever could.&nbsp; Suffice it to say that versioing a table creates supporting tables</SPAN><BR /><SPAN>and indexes, and the error indicates that a naming conflict exists on one of these</SPAN><BR /><SPAN>supporting tables/indexes.&nbsp; If you review the ArcSDE logs in $SDEHOME/etc and/or</SPAN><BR /><SPAN>the Oracle alert log, you should be able to determine exactly what has gone wrong.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Sat, 22 Sep 2012 20:00:32 GMT https://community.esri.com/t5/data-management-questions/ora-00955/m-p/533101#M30180 VinceAngelo 2012-09-22T20:00:32Z Re: ( ora - 00955 ) https://community.esri.com/t5/data-management-questions/ora-00955/m-p/533102#M30181 <HTML><HEAD></HEAD><BODY><SPAN>thank you very much , i delete the old ( A , D ) tables , then all thing is okay .</SPAN></BODY></HTML> Sun, 23 Sep 2012 11:53:11 GMT https://community.esri.com/t5/data-management-questions/ora-00955/m-p/533102#M30181 tamerali 2012-09-23T11:53:11Z Re: ( ora - 00955 ) https://community.esri.com/t5/data-management-questions/ora-00955/m-p/533103#M30182 <HTML><HEAD></HEAD><BODY><SPAN>It's premature to call everything "okay" until you can discover:</SPAN><BR /><SPAN>1) Why the old tables existed outside the maintenance of ArcSDE</SPAN><BR /><SPAN>2) What other tables might be similarly orphaned.</SPAN><BR /><SPAN>3) If any data of value has been lost in this process</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Sun, 23 Sep 2012 13:17:58 GMT https://community.esri.com/t5/data-management-questions/ora-00955/m-p/533103#M30182 VinceAngelo 2012-09-23T13:17:58Z