Multiple indexes for same column

Introduction

This post is about to create multiple indexes for the same column in Oracle EBS R12.

Script to create multiple indexes for the same column.

SQL>CREATE TABLE t3

(col1 NUMBER, col2 NUMBER);

TABLE created.

SQL>CREATE INDEX in_t3 ON t3(col1);

INDEX created.

SQL>CREATE INDEX in_t3_02 ON t3(col1);

CREATE INDEX in_t3_02 ON t3(col1)

* ERROR at line 1: ORA-01408: such fields are already exist.

SQL> CREATE bitmap INDEX in_t3_02 ON t3(col1)invisible;

INDEX created.

Summary

This post described how to create multiple indexes for the same column in Oracle EBS R12.

Got any queries?

Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.