Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Angry Unanswered: re: creating oracle spatial index

    hi! ,

    I am running oracle 9i on windows 2000 professional.

    I tried to created a spatialindex on a column of type mdsys.geometry.
    which has approxx 3.1 million rows

    the error message popped up while the process was running
    -- end of file communication channel..
    I reconnected to oracle
    when i try to drop the index i get the follwing error
    SQL> drop index rd_link_geo_idx;
    drop index rd_link_geo_idx
    ERROR at line 1:
    ORA-29868: cannot issue DDL on a domain index marked as LOADING

    can anybody shed any light on whats going on and how i can create the
    spatial index succesfully ..

    thanks a lot for your help ...

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    29868, 00000, "cannot issue DDL on a domain index marked as LOADING"
    // *Cause: Tried to issue a DROP/ALTER/TRUNCATE on a domain index in a LOADING state.
    // *Action: Wait till the index operation completes
    // OR issue a DROP INDEX FORCE to drop the index.
    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.

Posting Permissions

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