What a wonderful question:
“We are on Oracle 220.127.116.11 right now. Should we wait for Oracle 19 because of the proposed long term support for this release?”
I have gotten this question roughly 15 times in the past week, raised either by colleagues, customers or partners via email, twitter, in web conferences or (old fashioned way) on the phone.… [Read More]
The question sounds pretty trivial:
Which packages did exist in Oracle 18.104.22.168 but don’t exist in Oracle 22.214.171.124 anymore?
And going a bit deeper into the topic,
Which procedures and functions calls of SYS packages have been changed since then?
A colleague of mine (thanks to Thomas Kempkens from ACS Support for writing up a fancy procedure – all credits go to him) had to dig this out for a customer,
See the result.… [Read More]
Here is a new capability that might be interesting to anybody who is performing a migration using Data Pump. Previously, Data Pump would create indexes one at a time, specifying the PARALLEL keyword for the CREATE INDEX statement to invoke parallel query for index creation. We used to recommend a workaround to create indexes in parallel, which involved a three-step process of importing without indexes, then creating a SQLFILE of the CREATE INDEX statements, and breaking that file into multiple windows.… [Read More]