function based indexes on object tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: function based indexes on object tables

  1. #1
    Join Date
    Oct 2003
    Posts
    2

    function based indexes on object tables

    Hi,
    I am trying to create a function based index on an object table. I am getting the following error:

    SQL> create index cell1_indx on cell1(create_cell1(id)) indextype is mdsys.spatial_index;
    create index cell1_indx on cell1(create_cell1(id)) indextype is mdsys.spatial_index
    *
    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-13249: Stmt-Execute Failure: SELECT num_rows from all_tables where owner='ASHE' and table_name=
    'CELL1'
    ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 7
    ORA-06512: at line 1

    Here cell1 is an object table.
    Is the procedure for creating function based indexes on object tables different from relational tables?

    Chinni

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    can u drop the cell1_indx index? if not what message is returned

    steve
    I'm stmontgo and I approve of this message

  3. #3
    Join Date
    Oct 2003
    Posts
    2
    I am able to drop the index without any error message.

    chinni

  4. #4
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    Hi Gurus,

    ORA-29855 error occurred in the execution of ODCIINDEXCREATE routine

    Cause: Failed to successfully execute the ODCIIndexCreate routine.
    Action: Check to see if the routine has been coded correctly.

    Can someone guide how to CHECK the routine.
    Because this doesn't give a clear picture

    Cheers!
    Cheers!
    OraKid.

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