Invisible Indexes With Version 11g Oracle introduced invisible Indexes and I had several discussions with customers why it makes sense to create Indexes which are not used but maintained – because that’s what an invisible index is. Let’s have a closer look at the creation of indexes and why an invisible index might fit.
My Database becomes invisible Blogbeitrag lesen »
1. Migration Scenarios Over the past years I’ve done several Oracle database migrations to a different platform (e.g. HP/UX to Linux) to a different edition (e.g. Enterprise Edition to Standard Edition) or to Unicode. The most easiest one nowadays is the platform migration as Oracle offers some nice features like cross platform transportable tablespaces or RMAN cross platform backups or if you want to migrate from Windows to Linux vice versa you can simply setup a data guard environment. Of course there are still some pitfalls like the downtime but in general it’s straight forward and well tested.
Unicode Migration to Oracle 12c Blogbeitrag lesen »
