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.
Arun on Apr 02, 2019 at 12:01 am
This article is contributed by Arun. If you like dEexams.com and would like to contribute, you can write your article here or mail your article to email@example.com . See your article appearing on the dEexams.com main page and help others to learn.