I read data from a SDE database (Oracle) directly. How do I know, which format is used to store the geometry data? Do I have to check the DataType for the geometry column or is this information available in one of the global tables?
You can run the command "desc [feature class name];" in SQL Plus (Or any other way you access oracle"
Look at the Shape columns data type, that should tell you which Geometry type is used, for instance:
SQL> desc roads;
In order to get default geometry storage format (in most cases all your data will be in default format) you can run SQL query:
But this default variable can be overrided of course.
To get shape column name and type you can execute such SQL query:
Column type can have next values: