Index creation after a table restore

[Former Member]

Hi All,

We have ECC 6.06 landscape running on Oracle 11g and HP-Unix.

Due to some issue by ABAP Team, One table got deleted from database.

We had table definition existing in ABAP dictionary and ABAP Team also confirned that there is no dependency of this table data with others So with our third party DB tool we restored only that particular table.

Now after table restore we need to create indexes at database level, We have got list of indexes from ABAP Team which needs to be created.

I am thinking how we will know which type of index need to be created and what command we should use for index creation.

I can see the index definition from SE11 also but could not identify which type of index and what command to use.

Please suggest.

Regards,

Shivam

[manumohandas82]

Hi Sivam ,

What is the infomation you are missing . How to create an index in oracle is described in the note  .

What all indexes needs to be created  , depends on the table . Do you have a reference system?

Thanks ,

Manu

[manumohandas82]

Hi  Shivam

Please go through the following SNOTE

334224 - Important notes for creating indexes

If you search you will get many forums on this on SCN

Thanks ,

Manu

[Former Member]

Checked this note but did not find much required information there.

[Reagan]

If the index is present in Tx SE11 call Tx SE14 and create the index from there. You need to select the "Indexes" option from Tx SE14 and select the index to be created.