Skip to Content
author's profile photo Former Member
Former Member

How to delete an Index

Hi all,

I have a problem with deletion index, I am using oracle database.

The index is deleted in dev system and when i moved the transport for this to TST,

index is not getting deleted in Test. Can some one please assist me with this.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    Posted on Feb 12, 2009 at 09:24 AM

    Hello Sucheta, You can drop the table index from SE14 tocde at SAP level.

    enter the table name and excute select the indexes tab and then delete the index from there.

    Hope it helps

    Regards, Amber S

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Both suggestions are correct but i dont believe they answer the question.

      I dont know what the contents of the transport would look like that would drop the index on a table but to do it manually you could use sql if you have database access or use se14 which may not let you delete the primary index.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2009 at 12:17 PM

    Hello,

    Please try the following from OS level: Login as orasid user and connect to SQLPLUS and then try the below statement:

    DROP INDEX schema.index name;

    Regards,

    Pranab

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 07, 2009 at 06:14 PM

    Hi.

    Can you try with transaction SE14?

    I am not at work and so i have no possibility to check it bit i think it works with SE14 :o)))

    regards,

    Martin

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 20, 2009 at 02:33 PM

    Hi

    You would need to check the transport. Also please see from SE03 in your test system, if it reflects the table changes that have been imported from the transport.

    Please check if the following link is of some good to you :

    http://www.mirrorservice.org/sites/ftp.mysql.com/doc/maxdb/en/6a/c943401a306f13e10000000a1550b0/content.htm

    I hope it helps

    Regards

    Chen

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2013 at 09:09 AM

    To delete an index.

    1> goto se14

    2> enter table name choose tales

    3> press edit

    4> in tools bar press Indexes (F5)

    5> select the indexes one by one

    6> select delete index

    Note: You can not delete Primary index from database because it related with primary key and foreign key concept of RDBMS

    Thanks and Regards,

    Paramvirsinh Jetawat

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.