One of the things that sounded kinda neat in SQL Developer 3.1 was the Data Pump Wizards, so I thought I would have a play with them. SQL Developer 3.1 Data Pump Wizards (expdp, impdp) As you would expect, they are pretty straight forward. They can’t do everything you can do with expdp and impdp, [...]
I mentioned this when I blogged about my 11gR2 Virtual RAC install on Windows 2008. It came up in a conversation with Niall Litchfield at UKOUG 2011 and I’m reminded of it again today, after doing an 11gR2 install on Windows XP to double-check my answer to a question. Oracle database installs on Windows are [...]
Several years ago I met Arjen Visser and Bertie Plaatsman from Dbvisit and they told me about their standby database product, which is a replacement for Data Guard. Now I don’t spend much time on non-Oracle products, but this one was interesting to me as it works on Standard Edition, unlike Data Guard which is [...]
How many times have you heard someone say, “The rows always came back in the correct order, but since the *event* it’s now wrong. The *event* may be an upgrade or some maintenance task on the table etc. Oracle clearly say, “Use the ORDER BY clause to order rows returned by the statement. Without an ORDER BY clause, [...]
Some time ago I wrote an article about configuring DNS for the SCAN address in Oracle 11gR2 RAC. http://www.oracle-base.com/articles/linux/DnsConfigurationForSCAN.php Over the last couple of days one of the Oakies has given me some feedback on the article based on his experiences with Oracle Linux 5. For my virtual RAC installations I typically do the DNS [...]
I was ribbing Cary about missing his unconference session (due to migraine and alarm malfunction). Lenz Grimmer and I both tweeted him to see where he was and in return we received this message in reply. Very generous indeed. Unfortunately Lenz was flying home so he couldn’t make it. I had a conversation with Cary about it saying I [...]
I went to lots of good presentations over the three days. Day 1: SQL Tuning – Kyle Hailey Clonedb – Me (not counting myself in the “good” list, just placing myself in the timetable) OakTable Talks Emerging Trends in RAC – Julian Dyke Upgrading your Cluster to 11gR2 – Martin Bach Learning about life through [...]
Just finished my session. What a nightmare… I was surprised anyone turned up as it was a late change to the schedule and there were some great sessions going on at the same time. Check out the photo. It was kinda OK, until I got to the demo, which I screwed up. That was really disappointing because [...]
I missed the OakTable day because it was the 10th birthday party of nephew number 1, but I did make it back to Birmingham in time for the ACE dinner. Mark Rittman provided evidence of my presence here. I was already full of cake and trifle before I arrived, but the waitress didn’t seem to understand, “I’m not eating”, so I [...]