Spatial (MOSC)

MOSC Banner

Problem with sdo_geom.validate_geometry_with_context() in 10.2.0.4

edited Mar 30, 2010 3:05AM in Spatial (MOSC) 6 commentsAnswered
  I have a table with more of 35 millions of polygons. Less than 200 (all of them have at least a hole inside) give me errors with the validate function:

sdo_geom.validate_geometry_with_context()

 

This is a simple test of one element that reproduces the error:

/***************************************************************************************************/

create table test_poly (ID number(2,0) primary key, GEOMETRY mdsys.sdo_geometry);

insert into test_poly values(
    1,
    SDO_GEOMETRY(
        2003,
        8307,
        NULL,
        SDO_ELEM_INFO_ARRAY(1,1003,1, 11,2003,1),
        sdo_ordinate_array(
            -5.98129,37.38084, -5.98109,37.3807 , -5.98093,37.38069, -5.98091,37.38091, -5.98129,37.38084,
            -5.98109,37.3808 , -5.98098,37.38082, -5.98098,37.38073, -5.98101,37.38073, -5.98109,37.3808
        )
    )
);

INSERT INTO user_sdo_geom_metadata values(
    'TEST_POLY',
    'GEOMETRY',
    SDO_DIM_ARRAY(
        SDO_DIM_ELEMENT('LON',-5.98129,-5.98091,0.0000001), SDO_DIM_ELEMENT('LAT',37.38069,37.38091,0.0000001)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center