How to create a Database Index?

[Former Member]

I am trying to create an index on Z table. But it gives error 'Index does not exist in database system ORACLE'. What is the solution to it?

[Former Member]

Hi Pratiksha,

You might have created index with the primary key. The index already exists in the database. So create the index with other key. Delete the index and create the index with other key.

Regards

kannaiah

[Former Member]

1. Goto SE11

• don't forget to use the MANDT field as first field of any index for client-specific tables

2. Enter database table name fior which index needs to be created.

3. Press Change

4. Click on Idexes.

5. If no index is present, it will ask 'No index has been defined for table XXX, Do you want to create an index', click Yes.

6. Give unique index id.

7. Give short description.

8. Select Non-uniwue index type.

9. Define fields which will be used for indexing.

10. Save and activate.

Also refer

[Former Member]

May be, you have to activate the Index.

Try Transaction SE14.

Martin