I need to create a table/feature class with ArcCatalog 10.2 directly to a Oracle Spatial 11.2 database without ArcSDE, Is it possible? I can execute the create new feature class in ArcCatalog, but after I finish all steps of the wizard (I created a connection to the database with ArcCatalog (Add Database Connection), and clicked right button over that connection -> New -> Feature class) I have the following error: "Failed to create feature class. Undelying DBMS error [ORA-24344]" Could be a database problem? Perhaps something about privileges?
There are a lot of misconceptions on what "ArcSDE" is. I try to always make a clear distinction between "ArcSDE technololgy" (which is the connection protocol and core underpinnings of enterprise geodatabase implementation), an "ArcSDE application server" (the middle tier in the three tier enterprise geodatabase connection protocol), "ArcSDE Direct Connection" (the DLL implementation of the middle tier in a two-tier enterprise geodatabase connection), and "ArcSDE C/Java API" (the software used to maintain a connection and manipulate non-geodatabse spatial objects, which was also used to implement the Esri enterprise geodatabase model as part of ArcObjects).
In this case, you state you don't want to use "ArcSDE", but you've used both an enterprise geodatabase connection protocol (ArcSDE) and the ArcObjects tools that use the ArcSDE 'C' API (ArcSDE) to attempt table creation. If you really don't want to use ArcSDE, you need to be using a DAO or ODBC or JDBC or Python connection to submit SQL in the form of a "
CREATE TABLE" statement with an
MDSYS.SDO_GEOMETRY column. You can then visualize (but not edit) that table by accessing it through a Query Layer (provided that the table validates successfully). If you want to relax your "no ArcSDE" to "no enterprise geodatabase", then you can use the ability of ArcSDE connections to submit SQL commands for execution, though I prefer to submit DDL SQL from SQL*Plus long before I start Desktop.
Also of note, the only time ArcGIS utilizes "Oracle Spatial" is when a user embeds a Spatial-licensed package in a SELECT expression or WHERE clause (e.g.,
SDO_AGGR_CONVEXHULL). The low-level SDO_GEOMETRY type is part of the Locator package, which is installed with InterMedia in both standard and enterprise Oracle installs. Oracle Spatial is an additional cost upgrade to the basic capabilities of the Locator suite (contact your Oracle rep for licensing details).