Oracle Challenge #2 Solution

Apparently, quite a few people ran into this situation before, so I got a few correct answers  (some on Twitter, some on LinkedIn, and some as comments to the original post).

Continue reading

Advertisements

Oracle Challenge #2

I posted my first challenge almost 2 years ago and there was a lot of interest in it. Today I post another one.

Many years ago I saw this strange thing and it took me some time to realize what’s going on. Since then I ran into this scenario a few times, solving it instantly (and make a good impression at the same time).

Continue reading

Installing PSU (GI+RAC+JVM)

I’ve installed quite a few PSUs in my professional life, but this time, it was something else. I’m talking about a RAC environment with 2 nodes and a database containing JVM, so this was a complex patch to begin with. The problem is the the readme is incomplete and on top of that I ran into a few issues (some I could find on MOS but some I couldn’t). I’m writing this to assist anyone who needs to install this patch by providing the steps that worked for me. Please note that I patched 12.1.0.2 home, for other versions the steps might be a bit different.

Continue reading

Importing Into Existing Tables

I did some testing with impdp for a client. They asked me to write a procedure to import a set of tables from a production environment to a testing database. The import will include only a few tables, but not all, and will be performed to an already existing test environment that contains a full schema. And this process should be performed on a regular basis, so I looked for the best and easiest solution.

Continue reading