index problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: index problem

  1. #1
    Join Date
    Aug 2008
    Posts
    118

    index problem

    Hi,

    I am trying to create index TABLE_POSITION_A_IDX2 ON TABLE_POSITION_ADJ


    CREATE INDEX TABLE_POSITION_A_IDX2 ON TABLE_POSITION_ADJ
    *
    ERROR at line 1:
    ORA-00955: name is already used by an existing object
    but it gives me following error
    ORA-00955: name is already used by an existing object

    but when i try to drop the index by
    drop index TABLE_POSITION_A_IDX2 it says
    ORA-01418: specified index does not exist

    WHY!!
    please help!!

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,480

    Cool

    execute:
    Code:
    select * from dba_objects
    where object_name like 'TABLE_POSITION_A_IDX2'
    /
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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