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.
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:
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.
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
I exported 3 large tables from an Oracle 220.127.116.11.0 database then tried to import them into an Oracle 18.104.22.168.0 database but the impdp failed as follows:
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.
New whitepaper! The following topics are discussed in detail.A brief overview about closing work orders.
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, '
When Planning 22.214.171.124 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 126.96.36.199 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