All articles

Enhancing idql/iapi with rlwrap (part I)

The rant I have a confession to make: I’m obsessed with idql/iapi. These tools so central to Documentum administrative tasks are so lame for interactive work that they have probably disgusted more than their share of administrators. The problem is(…)

Automatic column formatting in Oracle sqlplus

Column formatting was always a pain in sqlplus when writing queries on the prompt. Most people use tools like SQL Developer or Quest TOAD which can scroll horizontally when running queries against a database, but as a consultant you are(…)

Getting started with Exasol – Sessions and auditing

This is the fourth post in the series about Exasol and this time it is about sessions and auditing. If you are interested in the previous posts you can find them here: Getting started with Exasol(…)

Getting started with Exasol – Some words about indexes and transactions

If you followed Getting started with Exasol – Setting up an environment and Getting started with Exasol – Loading data from PostgreSQL you should have an Exasol test system up and running(…)

Oracle ADB from a Jupyter Notebook

By Franck Pachot . My first attempt to connect to an Oracle database from a Jupyter Notebook on Google Colab was about one year ago: https://medium.com/@FranckPachot/a-jupyter-notebook-on-google-collab-to-connect-to-the-oracle-cloud-atp-5e88b12282b0 I’m currently preparing a notebook as a handout(…)

Getting started with Exasol – Loading data from PostgreSQL

In the first post of this series we brought up an Exasol test system to have something to play with. Because playing without data is a bit boring this post is about loading data from PostgreSQL(…)

Getting started with Exasol – Setting up an environment

Exasol is an in memory database with parallel processing, or shorter MPP(Massively Parallel Processing) database. I got in touch with some people from Exasol at the DOAG 2019(…)

Oracle MAA reference architecture and HA, DR, RTO, RPO

By Franck Pachot . I may have mentioned in some previous blog post that, in my opinion, the names of Oracle Database features make sense on the vendor product management context more than in a user context. I’m not(…)

ODA appliance creation error and cleanup.pl with option force

I had recently faced an interesting issue deploying ODA X8-2-HA. I would like to share my experience here hoping it could help some of you.

How to migrate High Availability databases on an ODA?

Through this blog, I would like to show, with a real customer case, how I have been migrating databases in High Availability environment on an ODA. High Availability using Data Guard for Oracle Enterprise Edition or dbvisit for Oracle Standard(…)