Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Location
    india,hyderabad
    Posts
    43

    Question Unanswered: re: creating a spatial index using dbms_job

    hi! Guys ,

    I am running Oracle 9i on windows 2000 professional.

    I am creating a spatial index on a table column.

    When i try to create it from sqlplus command prompt ..

    it errors out END OF FILE ON COMMUNICATION CHANNEL ..

    It was suggested to be run as a job using DBMS_JOB.

    I created a proc in which I use dbms_sql for creating the spatial
    index.

    I submit the proc as a job using DBMS_JOB.SUBMIT

    When I try to run the job using DBMS_JOB.RUN(32); where 32 is the
    job number it is bombing out.

    *******************************************
    submitted as job number 32

    PL/SQL procedure successfully completed.

    Elapsed: 00:00:00.00
    SQL> execute dbms_job.run(32);
    -29855ORA-29855: error occurred in the execution of ODCIINDEXCREATE
    routine
    ORA-13249: internal error in S

    PL/SQL procedure successfully completed.
    ********************************************

    Could any body help me resolve the issue and succesfully create the
    spatial index ????

    I have only oracle to work on this and not any applications like Arcse.

    thanks,
    harish


    __________________
    thanks,
    harish
    harry

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    <oracle@cosmora02d:/u01/home/oracle:334> oerr ora 29855
    29855, 00000, "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.
    <oracle@cosmora02d:/u01/home/oracle:335> oerr ora 13249
    13249, 00000, "%s"
    // *Cause: An internal error was encountered in the extensible spatial index
    // component. The text of the message is obtained from some
    // other server component.
    // *Action: Contact Oracle Support Services with the exact error text.
    <oracle@cosmora02d:/u01/home/oracle:336>
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2003
    Location
    india,hyderabad
    Posts
    43

    Angry when i try execute immediate 'sqlstatment'

    i get the following error

    *
    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: Error in R-tree: [mdrcritbl]
    ORA-13231: failed to create index table [] during R-tree creation
    ORA-29400: data cartridge error
    ORA-01031: insufficient privileges
    ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 7
    ORA-06512: at line 1
    ORA-06512: at "ITN_NEW.P_2", line 3
    ORA-06512: at line 1
    harry

  4. #4
    Join Date
    Sep 2003
    Location
    india,hyderabad
    Posts
    43

    Smile re: the problem solved

    hi! Guys ,

    FYI ...

    The problem was that I did not have enough space on the tablespace
    where the spatial index was being created.

    Increased the space and
    it created the spatial index.
    harry

Posting Permissions

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