Author: Karun Dutt

Problem Having decided to move our Oracle databases to the cloud, we now want to build equivalent VMs as database servers.  This is simple enough when we have only one or a very small number of databases. But this can…

After a recent upgrade Users cannot work with the forms application anymore; it has been a few weeks since an upgrade to Forms 12c. The usual suspects have been investigated. The database is not waiting on forms transactions The application…

Are there any questions? Crickets, absolute silence… Your meeting would have had one person speaking most of the time (you). The themes may have varied, but let us assume that it was about the need to “pull up” or otherwise…

The customer called us to cancel And now you have to break this news to the team. This is never an easy meeting. If you have read my previous post about emotional artifacts that manifest in High-Stress remote meetings, you…

How we got here When there is a high-stress emergency, why is it not enough to create a group of the best-skilled people and let them figure out what to do? What is all this emotional intelligence mumbo-jumbo? The classical…

Picture this: You are asked to join an urgent client meeting on a bridge call because the client is having production issues. You listen in on the crowded call, there are many participants on mute, and most of them have…

After setting up dg4odbc to connect to a SQL Server database (read ‘Tips on Using dg4odbc on 64-bit Linux’), I spent last week trying to get refreshes of materialized views to work in 11g, using the same DDL as in 8i. So, to those three tips, I now add #4: check the statements that use a WHERE … IS NOT NULL across the remote database link to ANSI-compliant databases.

I recently imported the contents of an Oracle 8i database into an 11g database. After following the instructions for a typical setupI set up a database link to a remote SQL Server database, and called it SQLSERVER.. It turned out that dg4odbc has “hard coded” the quotes and this will need to be changed in odbc.ini. I should have looked more closely at the installation instructions — yes, the example shows QuotedId=Yes.