on 01-28-2009 12:16 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 :
I hope it helps
Regards
Chen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.