Classes12 Jar For Oracle 11g New Features11/19/2022 To create multiple index on it column alter the session and set following attribute as true:Ĭreate index SI_Employee on Employee (Employee_ID) Ĭreate bitmap index BM_Employee on Employee (Employee_ID) Invisible Only one type of index on column is usable at a same time. Means if user create one index on column ‘a’ which is simple index and usable then user cannot create the index on same column. While creating multiple index-using oracle 12c the type of index should be different and only one type of index is usable at a time. Oracle 12c user will be able to create multiple indexes on same column.Prior to oracle 12c, user will be able to create single index on one column. In short a single SGA and background process will be shared to multiple databases, the databases can be created on fly and drop or attach and detach from one server to another server.This article will give you idea about Oracle 11g vs 12c. This is very useful methodology where database consolidation. This multiple databases are self-contained and pluggable from one database to another database. From 12c Onwards, the instance is shared with multiple databases. There are some newly added features in Oracle 12c over oracle 11G.In the article I will try to explain the newly added features in oracle 12c as well as Oracle 11g vs 12c. In my previous article, I have given the idea about the Oracle 11g new features.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |