English

FAQ: What does the SDO_VERIFY DBTUNE parameter do?

Question

What does the SDO_VERIFY DBTUNE parameter do?

Answer

When ArcSDE queries an Oracle Spatial feature class, it checks the SDE.DBTUNE table to determine which SDO_* parameters are set for the feature class. For polygon feature classes where SDO_VERIFY is set to TRUE or where the polygon feature class was autoregistered, ArcSDE checks the vertex rotation of each feature. (Normally, ArcSDE and Oracle Spatial expect exterior polygon boundaries to be stored in counterclockwise rotation, and inner boundaries to be in clockwise order.) If needed, ArcSDE corrects the vertex rotation before forwarding the feature to the ArcSDE client application.

Please refer to:

1. The ArcSDE for Oracle Configuration and Tuning Guide for more information about using DBTUNE parameters.

2. The ArcSDE Developer Help for more information about ArcSDE's shape verification rules.

3. The Oracle Spatial Users Guide and Reference for information about Oracle's shape verification rules.

Note:
As of the ArcSDE 9.x releases, the sdo_verify parameter in any dbtune keyword is now obsolete and cannot be used.