DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Gold Coast Austrlia


    I am trying to create a spatial index on data that contains point, line and rectangle geometries.

    Each time I have run the create script, I get the following :

    CREATE INDEX stabsame10_idx ON stabsame10(shape) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARAMETERS ('tablespace=treeidx2 initial=100M next =50M')
    ERROR at line 1:
    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-13249: Internal error in Spatial index: [mdrcrclmem]
    ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 7
    ORA-06512: at line 1

    However, when I check the status of the index in user_indexes :

    SQL> select status, domidx_status, domidx_opstatus from user_indexes where INDEX_NAME = 'STABSAME10_IDX';

    -------- ------------- ------

    Can anyone please tell me what I am doing wrong.

    By the way, the table contains 1 million rows. And.... there is enough free space in the tablespace, there is enough space in the rollback segment, and I have set sort_area_size to 200 million. Also - I have system privilages.


    [Edited by sankalp on 10-15-2002 at 11:21 AM]

  2. #2
    Join Date
    Oct 2002
    This error is due to incorrect Oracle database installation. Specifically, Oracle Spatial was not installed properly (actually, the Spatial library is not linked into the oracle executable).
    Problem can be solved as follows -
    The database should be shutdown when doing this.
    Login as unix user 'oracle'.
    $ cd $ORACLE_HOME/rdbms/lib
    $ make -f ins_rdbms.mk sdo_on
    or $ make -f ins_rdbms.mk sdo_on install

    Explanation -----------
    Oracle needs to be relinked with the spatial option turned on. In order to execute any of the internal spatial procedures, the Oracle executables will need to be linked with the spatial option turned on, see above syntax.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.