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.
Recent Posts
