We recently upgraded SDE to 10.0 SP3 (Oracle 10.2.0.4), and migrated over 200 feature classes to st_geometry spatial type. But "sdegroup -o create" failed to create a group feature class if st_geometry is the target spatial type (the source feature class is in st_geometry). I have to change to use sdebinary to make the command work. Does anybody know why?
We also experienced occasional arcmap crashes when labeling a few feature classes that were migrated to st_geometry. After recreating them in sdebinary spatial type, the crashes stopped. Anybody experienced such problems?
My clients all left Oracle 10gR2 after support by Oracle was terminated years ago. SDEBINARY is no longer supported because Oracle doesn't support LONG RAW; at this late date you should be using SDELOB as an alternate to ST_GEOMETRY, if necessary.
You should probably inspect the documented fixes for SP4 and SP5 to see if 'sdegroup' functionality was adressed. If the software doesn't work, you should contact Tech Support to create an incident, though any fix would likely be post-SP5.
If 'sdegroup' relies on SM_ENVP_BY_GRID (spatial index order), using ST_GEOMETRY with it might be suspect until 10.1 SP1. I haven't done any testing recently, but SM_ENVP_BY_GRID hasn't functioned as documented very often of late.
We are at Oracle 10.2.0.4. The upgrade was from ArcSDE 9.3.1 SP2 to ArcSDE 10.0 SP3 (ArcGIS Desktop is 10.0 SP3) I don't get any specific error message when using sdegroup command, except it quickly said it failed. When I changed to using sdebinary, it is ok. Anyway, it is ok for us to use sdebinary for now until next year when upgrading to 11g.
We finally narrowed down that only one feature class that, when using st_geometry, causes ArcMap to crash at labeling.
Oracle had LONG RAW in "deprecated" status for a long time. Many users have run into issues with SDEBINARY storage (which uses the LONG RAW type), and found that using SDELOB (which uses a LOB type) made their instance more stable. Oracle 11g does not support LONG RAW at all, so only SDELOB and ST_GEOMETRY are available with 11g.
What in particular are you doing with 'sdegroup'? I've been planning a utility I call 'sdecopy' which would accomplish a number of the same tasks, but will hopefully eliminate issues like the dangles across tile boundaries that are a feature of 'sdegroup'. It should cluster by attribute *and* tile as well.