Monthly Archives: June 2010

Enzee Universe Aftermath

Whew! The Enzee Universe this year was quite an experience. I would like to offer my sincerest thanks to all of you who attended the Best Practices session held in marathon-form on Monday before the keynote. Over 300 people signed up, and many of … Continue reading

Posted in award, consultants, enzee, independent, Netezza, opportunity, practice, thanks, twinfin, universe, voice | Tagged , | Comments Off

UDE-00018: Data Pump client is incompatible with database version 10.2.0.4.0

Had problems with EXPDP over a network link. Here’s how to do it and some problems you could encounter.

Posted in Oracle | Tagged , , , , , | Comments Off

ORA-55610: Invalid DDL statement on history-tracked table

ORA-55610: Invalid DDL statement on history-tracked table indicates that there is history tracking on the table, and you cannot therefore truncate the table. You can however delete from it.

Posted in Oracle | Tagged , , , | Comments Off

PLS-00201: identifier ‘QU_VERSION.MAJOR_NUMBER’ must be declared

Kept seeing an error on the database. Finally pinned it down to Toad.

Posted in Oracle | Tagged , | Comments Off

The Quote Operator.

There’s an interesting operator in oracle, the quote operator. Here’s how it work’s.

Posted in Oracle | Tagged , , | Comments Off

Silent De-install of Oracle Software.

Using the -silent option on the runInstaller means you can run it from the command line. Here’s how to de-install from the same method.

Posted in Oracle | Tagged , , , | Comments Off

Stop a users password from expiring.

In 11g, a profile password expires by default at 180 days. This can be a pain, and the means to stop this is to create another profile with unlimited password lifetime, then assign it to the user.

Posted in Oracle | Tagged , , | Comments Off

Prep for the Enzee Universe!

I know some of you are wondering if I have “gone dark” or something. But hey, there a conference comin’ up and I’m on the hot seat! Much of what will be discussed, I could (and may) post here eventually, but for now it’s time to burn this stuff in… Continue reading

Posted in Netezza | Tagged | Comments Off