cancel
Showing results for 
Search instead for 
Did you mean: 

How to delete an Index

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

former_member198270
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.

Answers (4)

Answers (4)

Private_Member_739866
Participant
0 Kudos

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

Former Member
0 Kudos

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/cont...

I hope it helps

Regards

Chen

martin_juen2
Contributor
0 Kudos

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

Former Member
0 Kudos

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