All articles

“_suppress_identifiers_on_dupkey” – the SAP workaround for bad design

By Franck Pachot . In SQL, 'upsert' is a conditional insert or update: if the row is there, you update it, but if it is not there, you insert it. In Oracle, you should use a MERGE statement for that.

Oracle Big Data Cloud Service – Compute Edition

In this blog post, we will see how to create a Big Data cluster through the Oracle Cloud Services. If you want more details about the Oracle Big Data cloud services offering, you can refer to my previous blog(…)

Introduction to Oracle Big Data Services

Since few years, Oracle decided to move forward in the Big Data area, as their main competitor. The goal of this blog post is to explain you, how the Oracle Big Data offering is composed. As the Oracle Big Data(…)

Announcing the dbi OpenDB Appliance

As already announced on Twitter and LinkedIn here is the blog post to describe our OpenDB appliance in more detail. I am sure you wonder what this is about so let me explain why we are(…)

Searching wikipedia from the command line

Wouldn't it be nice if you could search wikipedia from the command line? I often need to quickly look up a definition or want to know more about a specific topic when I am working on the command(…)

When deterministic function is not

By Franck Pachot . When you declare a function-based index, the function is deterministic, which means that calling it with same arguments will always return the same result. This is required because the indexed values, which are the result of(…)

Using WebLogic 12C RESTful management for monitoring WebLogic Domains

WebLogic 12.2.1 provides a new RESTful management interface with full accesses to all WebLogic Server resources. This interface offers an alternative to the WLST scripting or JMX developments for the management and the monitoring of WebLogic Domains. The following of(…)

Am I a DBA 3.0 or just an SQL*DBA?

By Franck Pachot . There are currently a lot of new buzz words and re-namings which suggest that our DBA role is changing, most of them escorted with a #cloud hashtag. Oracle Technology Network is now called Oracle Developer Community.

Wrong result with multitenant, dba_contraints and current_schema

By Franck Pachot . Multitenant architecture is not such a big change and this is why I recommend it when you start a project in 12c or if you upgrade to 12.2 - of course after thoroughly testing your application.

Documentum – RCS 7.3 – Issue with projections?

In the last two blogs I posted, I mentioned that I was working on silent installations with CS 7.3 (in HA). The “issue” (it’s more like a common mistake) I will describe in this blog is linked to the HA installation.