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 Data Pump import:
While testing a migration, I figured out that schema export using Data Pump doesn’t capture public synonyms on the objects in this schema. Does anyone know how to make Data Pump include public synonyms with schema export? Update: This is actually the same behavior as old Export utility.
The sixteenth edition of Log Buffer, the weekly review of database blogs, has been published by Guy Bowerman on his blog, Informix Application Development.
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? Visit Google Trend and enter “oracle 8i, oracle 9i, oracle 10g” and take in the popularity trends.
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 method now and not the next time it happens.
This video ran before Dell’s keynote at Openworld. I’m just not sure what more to say; you’ve just got to see it for yourself.
In this post I compare Oracle Enterprise to Standard Editionand and proviode a features matrix outlining the diffrences between them.
It’s not academic research about us, The Pythian Group, but rather about our inspiration for our company’s name, the actual young woman who was the Pythian priestess, the Oracle of ancient Greece who would give her pronouncements at Delphi.
Welcome to another edition of Log Buffer, the weekly compendium of news from the database blogoshpere.
As I was poking around metalink, I found the following extremely interesting section. It’s in a very obvious place, but it’s new, so many of you may have not noticed it. It’s called “Support case studies” and provides some amazing articles.