English

How To: Load Oracle NORMALIZED layers into ArcSDE 8 (dbtune entries note)

Summary

You need to use SDE 3.x dbtune.sde-style parameters for Oracle Normalized schema layers to load into ArcSDE 8. Use the parameters below instead of those listed in the document 'ArcSDE for Oracle Configuration and Tuning Guide' included with ArcSDE 8.0.x.

Procedure

  • Load fails with these (sample) parameters:

    ##NORMALIZED
    GEOMETRY_STORAGE NORMALIZED
    SDO_ORDCNT 16
    SDO_VERIFY TRUE
    SDO_LB_1 -180.0
    SDO_UB_1 180.0
    SDO_TOLERANCE_1 0.0005
    SDO_LB_2 -90.0
    SDO_UB_2 90.0
    SDO_TOLERANCE_2 0.0005

    END

  • Load works with these parameters:

    ##NORMALIZED
    GEOMETRY_STORAGE NORMALIZED
    ORDCNT 16 # Number of ordinate values per row (recommended)
    TESSELLATION 2 # Number of index iterations (up to 32)
    VERIFY_GEOMETRY TRUE # SDE will verify the geometry
    DIM_X_LOWER -180 # Lower bound of X extent
    DIM_X_UPPER 180 # Upper bound of X extent
    DIM_Y_LOWER -90 # Lower bound of Y extent
    DIM_Y_UPPER 90 # Upper bound of Y extent
    DIM_TOLERANCE 0.00005 # Point at which two coordinates no longer differ

    END