Dropping partitioned index - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Dropping partitioned index

  1. #11
    Join Date
    Nov 2000
    Location
    London
    Posts
    83
    No to both questions I'm afraid.

  2. #12
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by Fiona
    I did try and rebuild it, only to get error message

    ALTER INDEX BM7 REBUILD PARTITION P9 TABLESPACE P_3_NEW;
    ERROR at line 1:
    ORA-01418: specified index does not exist

    DBA_SEGMENTS table clearly shows that old tablespace contains index BM7 and not in P_3_NEW where I want to rebuild it.

    Jus check this might be the case.Had u created a index or partioned index with the name in doube quote ("indx_name")...ther lies the probs.
    Code:
     
    SQL> alter index emp_id rebuild;
    alter index emp_id rebuild
    *
    ERROR at line 1:
    ORA-01418: specified index does not exist
    
    
    SQL> alter index "emp_id" rebuild;
    
    Index altered.
    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #13
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by slimdave
    Your index name isn't mixed case or anything is it, or owned by a different user?
    gues we posted almost same time.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #14
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    the thing is you first said you get

    ORA-01418: specified index does not exist

    then how come you can rebuild an index which does not exist?

    then it seems that you can see the index in dba_ind_partitions so I am wondering, are you rebuilding the index with the proper user?

  5. #15
    Join Date
    Feb 2000
    Location
    Brisbane, Australia
    Posts
    46

    Thumbs down

    Hi, pando. When is your new book being released: "How to Lose Friends and Alienate People?"

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