How to revert back of secondary indexes created?

[Former Member]

Hi all,

I have craeted secondary indexes in development and they have been transported into quality and production. Some dumps are coming in the production because of these secondary indexes.

Please guide me how to revert back those secondary indexes from production(means to keep original with out that secondary indexes?)

Please give me solution.

Regards,

Lokesh

[Former Member]

Hello,

The best way to do this is delete the indexes again in DEV and create a transport request.

Transport this request to QA and PRD and the index will be deleted.

Via SE14 you can also delete the index immed in PRD.

SE14 will only delete the index from the database (shortdumps will disappear then).

Afterwards you can still use SE11 to delete the index from the SAP repository as well.

Success.

Wim

Edited by: Wim Van den Wyngaert on Nov 20, 2009 1:08 PM

[Former Member]

Hi Friend ,

DELETE the Secodary index and Transport the request .

Regards

[Former Member]

Hi Lokesh ,

Please check exactly why is this happening ?

Keep , reverting the changes as last option , first find cause and exactly at which place is this going on.

If you change index , worst can be that database time increase and not a short dump.

Short dump can be only when online execution in more than 20 min.

First do impact analysis and then only take a step.

[kesavadas_thekkillath]

Duplicate thread,

Read the forum Rules !!!

[matt]

Duplicate deleted. Please do not post the same question in more than one forum