APPEND_VALUES hint ignored for table with spatial index column
Hi,
OS = OEL5, database = 11.2.0.4
It looks like the APPEND_VALUES direct path insert hint is ignored on tables with a spatially indexed column. Test case as follows...
CREATE TABLE SpatialTest_table
(ID INTEGER,
Location MDSys.SDO_Geometry)
STORAGE (INITIAL 1M
PCTINCREASE 0
NEXT 1M);
------------------------------------------------------------
-- Set up Spatial metadata for indexing of Location...
------------------------------------------------------------
INSERT INTO User_SDO_Geom_Metadata
(TABLE_NAME,
COLUMN_NAME,
DIMINFO,
SRID)
VALUES
(
'SPATIALTEST_TABLE',
'Location',
SDO_DIM_ARRAY
(
SDO_DIM_ELEMENT('Longitude',-180,180,1),
SDO_DIM_ELEMENT('Latitude', -90, 90,1)
),8307);
commit;
CREATE INDEX SPATIALTEST_TABLE_SI1
ON SPATIALTEST_TABLE(Location)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
PARAMETERS
('Layer_gType=POINT Tablespace=USERS SDO_Non_Leaf_Tbl=TRUE SDO_RTr_PctFree=0 Initial=1K PctIncrease=0 Next=1K');