Deletion of Index

[Former Member]

Hi all,

I have a problem with deletion index. One of our functional guy has deleted an index in dev system and when i moved the transport for this to TST, index is not getting deleted in TST. Can some one please assist me with this.

Regards,

Sandhya

[Former Member · Accepted solution]

Hai,

What is your DB?

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

DROP INDEX schema.index name;

Regards,

Yoganand.V