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 Arun. If you like dEexams.com and would like to contribute, you can write your article here or mail your article to admin@deexams.com . See your article appearing on the dEexams.com main page and help others to learn.
Search
Search
