Oracle Virtualization and Cloud Consulting
view counter

Feed items

Subquery Factoring (9)

Several years go (eight to be precise) I wrote a note suggesting that Oracle will not materialize a factored subquery unless it is used at least twice in the main query. I based this conclusion on a logical argument about the cost of creating and using a factored subquery and, at the time, I left it at that.

iptables start on boot – Ubuntu/Debian

By default Ubuntu/Debian OS wont load iptable on boot.
So to load iptables on boot use follow procedure:
Save iptable conf with iptables-save command:
iptables-save > /etc/iptables.conf
Next, open file with name /etc/network/if-up.d/iptables and add following content:
iptables-restore < /etc/iptables.conf

Change permission file /etc/network/if-up.d/iptables as executable with following command:

Does the mobile web experience really suck? The enterprisey redux

The Verge's Editor in Chief recently made the case that the mobile web sucks. Behind the diatribe is a debate that impacts how we think about UX - and how we should respond.

Author information

Jon Reed

Jon Reed has been involved in enterprise communities since 1995. These days, Jon is a roving blogger/analyst, and also counsels vendors and startups on go-to-market strategy. He is a diginomica co-founder, Enterprise Irregular, and purveyor of multi-media content. Jon is an advocate f

Click on the link for the full text/media - @jonerp

ORA-39001, ORA-39000 and ORA-39142

I exported 3 large tables from an Oracle database then tried to import them into an Oracle database but the impdp failed as follows:

Lighty In A Nutshell

As you may know from a previous post on this blog, or if you follow me on Twitter (BPeaslandDBA), I like Lighty for Oracle, a product by Orachrome. I love this product and how easy it is to obtain performance diagnostic information. I’m very familiar with Oracle’s Enterprise Manager and I use EM12c all the time when I get calls about poor database performance. But I am now hoping that Lighty becomes another tool in my arsenal.

Troubleshooting the Closing of Work Orders in EAM and WIP

New whitepaper!  The following topics are discussed in detail.A brief overview about closing work orders. 

ORA-22926 when using getClobVal to convert XMLType to CLOB

I ran into a problem the other day when moving some code from one database to another (both XE 11g). The code in question needs to convert an XMLType to a CLOB to do some (hacky) string manipulation on it, and then turn it back to an XMLType.

Here's the original code:

  l_xml := apex_web_service.make_request(...);
  -- little hack to remove bad empty namespace from result
  l_clob := l_xml.getClobVal();
  l_clob := replace (l_clob, '', '');

Planning with ODI

Just a quick post from me today which has taken me ages to get around to writing up.

When Planning was first released there was no official ODI adaptor to coincide with the release, there was so much talk around there wasn’t  going to be a 12c release that seemed to get lost in the confusion.

If you want to read more on this subject then there is a good Oracle support document available

view counter