Oracle Migration - Poll results and DBUA in Oracle Database 12c.

In an earlier blog post some time ago I did a survey on how you migrated your last database. I asked if you used the DBUA, manual upgrades and a handful of other methods. The results, though not a huge representative sample, were interesting. If you would like to fill out the survey you can find it here.

The results seem to imply that people prefer to use manual upgrades. I've been among those folks, but with Oracle Database 12c, I'm starting to like the DBUA.

The DBUA shipped with Oracle Database 12c, has many new features and is worth looking at as you start your upgrade planning to move your databases to Oracle Database 12c. New features such as being able to roll back a failed upgrade and then restart the upgrade after you have fixed whatever the problem is that caused the failure, are really nice to have. The ability to run the upgrade prerequisite script and then correct many of the problems that it detects from DBUA is also a very welcome feature. You can also update the timezone data, recompile objects and even re-run statistics from the DBUA. All in all, the DBUA is worth a second look!

Here are the current results for the poll.

Interesting...!