span8
span4
span8
span4
Dear FME 亚搏国际在线官网community.
I try to integrate data into ORACLE but FME say me :error was `ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
Do you know what does that mean ?
Thanks
This usually means that the coordinates of the features are within the table tolerance and therefore Oracle rejects the features or cannot create the spatial index.
I suggest changing the tolerance of your table by re creating the tabel's entry in the user_sdo_geom_metadata table or making sure the coordinates are within the acceptable tolerance try the Generalizer transformer.
Hope this helps,
Itay
Thank you great !
This is my request :
DELETE FROM user_sdo_geom_metadata WHERE TABLE_NAME = 'MYTABLE';INSERT INTO user_sdo_geom_metadata (TABLE_NAME,COLUMN_NAME,DIMINFO,SRID) VALUES ('EDTG_BATI_PARKING','GEOMETRY',MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',-2147483648,2147483647,5E-5),MDSYS.SDO_DIM_ELEMENT('y',-2147483648,2147483647,5E-5),MDSYS.SDO_DIM_ELEMENT('z',-2147483648,2147483647,5E-5)),2154);DROP INDEX EDTG_BATI_PARKING_ARCH_GMIDX;CREATE INDEX EDTG_BATI_PARKING_ARCH_GMIDX ON EDTG_BATI_PARKING(GEOMETRY)INDEXTYPE IS MDSYS.SPATIAL_INDEXNOPARALLEL;
how can i write to two databases symultaneously2 Answers
how to convert (x And y) data table in oracle to shapefile and save it in the oracle database?2 Answers
Conversion of BIM models to GIS1 Answer
ArcSDE: Write empty geometry instead of NULL geometry in FME1 Answer
Query A Date Field To Only Return <=90 Days From Current Date4 Answers
© 2019 亚搏在线Safe Software Inc |Legal