Help needed in Oracle Spatial
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Help needed in Oracle Spatial

  1. #1
    Join Date
    Oct 2002
    Location
    Gold Coast Austrlia
    Posts
    2

    Question

    Hi,
    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';

    STATUS DOMIDX_STATUS DOMIDX
    -------- ------------- ------
    VALID VALID FAILED

    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.

    Sankalp


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

  2. #2
    Join Date
    Oct 2002
    Posts
    1
    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