Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> oracle spatial: change the spatial tolorance and round the values in the fields (hope to solve ORA-04031 messages with this)

oracle spatial: change the spatial tolorance and round the values in the fields (hope to solve ORA-04031 messages with this)

From: <eywitteveen_at_gmail.com>
Date: Wed, 17 Oct 2007 02:31:53 -0700
Message-ID: <1192613513.229205.113110@i38g2000prf.googlegroups.com>


Hello,

I want to change the tolorance from: 0.00001 into: 0.005, Is there a way to update this column so the value is rounded and simplified, so the value is filled with values which do not contain too much decimals behind the "."?

I want to change the tolorance of a table that i have, so oracle doesnt have to do unused work(and give error ORA-04031: ..."large pool".. on index usage).

query i want to run:
pand table: 13124 records with polygons
number table: 14070 records with points

CREATE TABLE NUMMER_IN_PAND AS
SELECT
  PAND.GID AS PAND_ID,
  NUMMER.GID AS NUMMER_ID
FROM
  PAND,
  NUMMER
WHERE
  SDO_RELATE(PAND.GEOM, NUMMERAANDUIDING.GEOM, 'mask=CONTAINS querytype=JOIN') = 'TRUE'
(i also tried adding a mbr column to the table "pand" and do 2 contain
statements, used querytype=window, so i'm more / less clueless what to do next)

Currently my geometry column is filled with the following information like the following:
INSERT INTO USER_SDO_GEOM_METADATA
(

  TABLE_NAME,
  COLUMN_NAME,
  DIMINFO,
  SRID
)
VALUES
(

  'pand',
  'geom',
  MDSYS.SDO_DIM_ARRAY(
    MDSYS.SDO_DIM_ELEMENT('X', -7000, 300000, 0.00001),     MDSYS.SDO_DIM_ELEMENT('Y', 289000, 629000, 0.00001 )   ),
  90112
)

Furthermore, if this is not the path to follow, what else should i do? Received on Wed Oct 17 2007 - 04:31:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US