I'm needing some information about the pros and cons of using Oracle Spatial vs. using SDE with SQL 2000. All information will be helpful including any about using Smallworld with Oracle Spatial. Thanks.
Major point (IMO) in favor of Oracle Spatial is that most (all ?) of the commercial GIS tools support Oracle Spatial. This means that customers can choose and combine the tools that suit them best for the task at hand. Note that ArcSDE can also use Oracle Spatial together with its own binary storage format.
Also Oracle runs on most platforms (Unix, Linux, W2K, ...).
I think I can help here if you have not resolved this yet. When you use Oracle with the "standard" storage format(not spatial), the performance should be better. But as mentioned before, oracle spatial type storage can be used by more than ArcSDE. Oracle spatial type storage does not store your data in a binary format which drops the perfomance slightly.
Hope this helps and good luck.
Don't use Oracle Spatial with SDE it is better to use just Oracle Spatial and then you are not stuck with ESRI as a client and go for a real enterprise solution involving different GIS apps which allows you better interoprability, also it is a lot cheaper. MapInfo, Cadcorp SIS, GeoMedia all link to Oracle Spatial direclty and using SDE on Oracle will not allow these to use access it unless it is set up in a specific way which is a pain and does not add anything to the functionality.