Hi Thomas,
1. Try create spatial index from sql window.
if you get the same errors, it is roacle problem, not
FME.
sql> CREATE INDEX IMAGE_VAULT_SIDX ON
IMAGE_VAULT(GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX;
2. or it could be some oracle packages missing.
3. ORA-13236 - needs oracle support.
regards,
victor Dominic
--- Thomas Chan <[EMAIL PROTECTED]> wrote:
> 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
>
>
> [EMAIL PROTECTED]
>
>
>
>
>
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
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/
