When Oracle are adding a new feature to the database, they usually add a parameter to control it. Sometimes, after adding feature and the parameter, they realize that the parameter they chose for controlling the feature is not suitable. It might be confusing, or too general or something else. In these cases they change the parameter in the following version.
Starting with Oracle 12.1 we can export views as tables. This means that the export will contains a “create table” command and its data, while the original object was actually a view.
Remember my post about Oracle 12.2 release date? I’ve heard rumors that Oracle changed the date to March 1st, and it was right!
Oracle 12.2 is available for download for Linux x86-64, and Solaris (both SPARC and x86-64). I don’t know the release dates for other platforms. This is the download page: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
I’m downloading it as I write, and hopefully will have time to play with it a little bit soon. I wrote so much about new features that I have to try some of them at least. Stay tuned!
A few days ago I was browsing the documentation and suddenly realized that I haven’t gone over the 12.2 books. One of the things I like to do is reading the “New Features” guide, so I did. After writing about the major features, here are some smaller ones, but still important enough to know.
If you’ve read my post about 12.2 new features and liked it, you will like this one as well. I’ve recently looked at presentations from OOW16, and found one by Keith Laker from Oracle. Keith, as principal PM for analytic SQL, talked about DWH features in 12.2, and they are great.
I’d like to thanks Keith for uploading the presentation. I will review some of the feature from the presentation, and will only mention the them without a deep explanation. There is a link to the original presentation below.
Lately I wrote a post about 12.2 new features. In the post I didn’t list sharding (probably one of the biggest features in this version), as I wanted to dedicate an entire post for it. In this post I will cover this option , but please note, as 12.2 is only released for the cloud and no one can install it and play with it, all the information is based on presentations I’ve seen at OOW and a chat I had with one of the developers in the demo ground. There might be some inaccuracies or mistakes in the post.