All articles

12cR2 Cross-container DML – insert into container()

By Franck Pachot . Multitenant has been introduced in 12.1.0.1 with the goal to share resources but isolate data. However, having all PDBs in the same root may be convenient to manipulate data in multiple PDBs. In the first patchset,(…)

Personal road trip – PowerShell Conference EU 2017

Welcome to PowerShell Conference EU 2017 Started on April, 5th at 9:00 AM, I was immersed in a wonderful and amazing Open Ceremony among light effects and an epic music. Indeed, using PowerShell is always an epic moment…(…)

APEX Connect 2017 – Day 3

For the last conference day, after the Keynote about “JavaScript: The next Language YOU should learn” by Dan McGhan , I decided to attend presentations on following topics: – Upgrade your APEX app with zero downtime by using EBR(…)

SQL Server 2017: Python server

After my article SQL Server 2017: first steps with Python Service, I write this article about my first test with the Python Server feature in SQL Server 2017. The installation(…)

APEX Connect 2017 – Day 2

After the Keynote about “Oracle Application Express – Ahead of it’s time. Leading the way forward” by Joel Kallmann (Director of Software Development for APEX) and some overall presentation about Development with APEX 5.1, I decided to attend presentations on(…)

Upgrade to Oracle 12.2 with dbupgrade utility

By Mouhamadou Diaw Oracle 12.2 is released and we will have to upgrade. And in this blog we are going to talk about upgrading to oracle 12.2 using the dbupgrade utility. Of course the dbua tool is still available and(…)

SQL Server 2017: first steps with Python Service

Last year, I written blogs about SQL Server 2016 and his integration from the R language. Just for information, you can find these blogs about SQL Server 2016 R Services here: SQL(…)

APEX Connect 2017 – Day 1

This year again the APEX connect conference spans over three days with mixed topics around APEX, like JavaScript, CSS, SQL and much more. After the welcome speech and the Keynote about “Reconciling APEX and the Thick Database Paradigm” by(…)

Grid Infrastructure Installation on SLES 12 SP1

This week I needed to install Oracle Grid Infrastructure 12c release 1 in a SLES 12 SP1 environment. Everything worked fine until I ran the root.sh at the end of the installation. Here’s a quick description of the problem and(…)

What is in a transportable tablespace dumpfile?

By Franck Pachot . On 31st of May in Düsseldorf, at DOAG Datenbank, I'll talk about transportable tablespaces and pluggable databases. Both methods are transporting data physically, the difference is in the transport of the metadata,(…)