Oracle 19c AutoUpgrade Utility

The AutoUpgrade utility introduced with Oracle 19c identifies issues before upgrades, performs pre- and postupgrade actions, deploys upgrades, performs postupgrade actions, and starts the upgraded Oracle Database. In this article we’ll see how this new autoupgrade utility almost completely automates the database upgrade process including pre & post upgrade tasks. The autoupgrade.jar file is available…

12c New Features – Invisible Columns

There can be several situations where you want to test the impact of dropping a column from a table, till 11gR2 Oracle provided an option to mark a column as UNUSED before dropping a column, and do ALTER TABLE … DROP UNUSED COLUMNS at a later time but marking a column UNUSED is a irreversible…