If you are using Oracle Data Pump to backup tables containing LONG or LONG RAW columns, then you might be surprised when trying a recovery. Well, you tested it already. Didn’t you?
Right now I’m in the middle of a production migration. Earlier this week while testing this migration, I noticed couple strange errors during [...]

While testing a migration today with one of our clients, I figured out that schema export using Data Pump doesn’t capture public synonyms on the objects in this schema. This behavior is different from the older Export utility which includes public synonyms with schema objects. Update: This is actually the same behavior as old Export [...]

A few days ago Kevin Closson (keep an eye on this new blog and expect to find something interesting there) mentioned that Oracle 8.1.7 is one of the most mature releases (at least I understood it this way). I agree with him that many people still use it but how many? Google Trend is our [...]

This will help when you need to investigate some past changes to your database when auditing was not enabled. This doesn’t imply that you don’t need auditing. On the contrary, I see no reason not to use it in any and every database. However, often we get systems “as is” and we need a working [...]

How many times did you find yourself looking whether a certain feature is part of Oracle Standard Edition or it requires an Enterprise license?
I used to find myself in that situation quite often. I know there is a feature matrix somewhere but every time I end up looking for it over and over again. Worse [...]