Multiple indexes on the same column cannot be created in prior version of Oracle.
With oracle 12c this is possible but multiple indexes must be different types like BitMap,B-Tree etc.
The maximum size of the VARCHAR2, NVARCHAR2, and RAW data types has been increased from
4,000 to 32,767 bytes.
Note -VARCHAR2 length is increased to 32767 in Oracle 12CR2.
This article is contributed by Arrrsh. If you like dEexams.com and would like to contribute, you can also write your article here or mail your article to firstname.lastname@example.org . See your article appearing on the dEexams.com main page and help others to learn.
Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.