Primary key constraints in Oracle are enforced by using an index. The index does not need to be a unique index, but it has to be possible for the database to look into it and find out if a given key is already present or not. This works fine, as long as the index structure … Continue reading How to take care of index corruptions in primary key indexes.
When I first got in contact to the possibility to bring back a database to the state it had, when a backup was taken I was not too much impressed. I though "Well, it's like any other backup - copy the saved file back to the place I found it." Getting deeper into the tasks … Continue reading Point-in-time-recovery considered harmful
A few months ago, I described how to set up and configure the Windows Debugger in order to be able to generate a call stack for a hanging MaxDB thread. As this was technically interesting (at least I hope so), it is by far not the simplest way to get a call stack for a … Continue reading Debugging the MaxDB Kernel – How to get a Call stack the easy way