This is a technical note about unusable indices in transportable tablespaces. The presence of these cause the import to report errors. This bug is fixed in 18.2.
From an operational perspective, I argue that the use of ANSI syntax for JOINs is superior to that of Oracle’s native syntax.
Now that Flashback Data Archive is now included in the base 188.8.131.52 license, I had the crazy idea to mix it with Database Editioning.
I have recently used SQLTXPLAIN to solve a production performance issue. This post is about my experiences with this tool.