Hi,
I am currently running FME 2004 ICE for Oracle build 1314.
I am having difficulties creating Spatial Index (R-Tree Index) for Oracle 10G
Spatial features (Object Model)with more than 100,000 records.
I got the following errors when attempting to load a SHP to Oracle 10G. The
FME process fails while trying to create the index.
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: Error in Spatial index: index build failed
ORA-13236: internal error in R-tree processing: [failed to cluster in memory]
ORA-13232: failed to allocate memory during R-tree creation
ORA-13236: internal error in R-tree processing: [failed to allocate memory
8814600 (mdrtsalloc)]
ORA-04031: unable to allocate ORA-04031: unable to allocate 8814648 bytes of
shared memory ("larg'. (serverType=`ORACLE8i', serverName=`DEV_10G',
userName=`LATLONG', password=`***', dbname=`')
2005-08-10 16:02:06| 221.1| 0.0|ERROR |Execution of statement `CREATE INDEX
IMAGE_VAULT_SIDX ON IMAGE_VAULT(GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX' did not
succeed; error was `ORA-29855: error occurred in the execution of
ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: Error in Spatial index: index build failed
ORA-13236: internal error in R-tree processing: [failed to cluster in memory]
ORA-13232: failed to allocate memory during R-tree creation
ORA-13236: internal error in R-tree processing: [failed to allocate memory
8814600 (mdrtsalloc)]
ORA-04031: unable to allocate ORA-04031: unable to allocate 8814648 bytes of
shared memory ("larg'. (serverType=`ORACLE8i', serverName=`DEV_10G',
userName=`LATLONG', password=`***', dbname=`')
The error log from FME suggested that the Oracle server run out of memory, but
our DBA suggest that it is not a memory allocation issue, but rather the
software used to load the dataset and I am wondering if anybody has run into
similar situation?
Thanks,
Thomas Chan
GIS Specialist/Project Manager
TELUS Geomatics
780 493 3237 Telephone
780 493 4569 Facsimile
[EMAIL PROTECTED]
www.telus.com/geomatics
TELUS
Business Solutions
16A, 10020 - 100 Street
Edmonton, Alberta
Canada T5J 0N5
Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our
Professional Services team. Visit www.safe.com/services for details.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
