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.
I wrote in the past about my frustration with Oracle support. I also hear from customers and colleagues about their frustration with Oracle support, from different reasons. People like to complain when something doesn’t work well, however, I’m writing this post to tell about excellent experience I had with the support lately.
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.
I’ve written a few “diagnostics” posts in the past (you can see them all under the “Troubleshooting” category). People really like these type of posts, and I got many comments about them in the past (good ones…), so here is another case that I had not too long ago.
I’d like to thank Kadhir Velavan, he is the guy who brought this to my attention and we worked on this issue together.