Oracle Team

12c upuserxt.lst, upobjxt.lst & Oracle Maintained objects/users

By Franck Pachot . Mike Dietrich has blogged recently about upuserxt.lst and upobjxt.lst and how to query them with external table. The first time I've seen those '.lst' files, the default extension(…)

PDB RMAN backups available after plugging in on a new CDB with Oracle 18c

With Oracle 18c, it is possible to use PDB rman backups created on the source CDB (they are called PREPLUGIN backups) when the PDB has been relocated to a target CDB. In my environment, my original CDB is DB18, with(…)

ADWC – connect from your premises

By Franck Pachot . In the previous post about the Autonomous Data Warehouse Service, I've run queries though the Machine Learning Notebooks. But you obviously want to connect to it from your premises, with SQL*Net.

SQL Developer Web on the Oracle Cloud

By Franck Pachot . You like SQL Developer because it is easy to install (just unzip a jar) and has a lot of features? Me too. It can be even easier if it is provided as a web application: no(…)

Some ideas about Oracle Database on Docker

By Franck Pachot . This is not a 'best practice' but just some ideas about building Docker images to provide an Oracle Database. I started with the images provided by Oracle: https://github.com/oracle/docker-images/tree/master/OracleDatabase/SingleInstance and this is great(…)

idql and its column output

idql and its column output A few days ago, I was reading an interesting blog from distinguished colleague Clemens Bleile with the title “sqlplus and its column output” (link here https://www.dbi-services.com/blog/sqlplus-and-its-column-output/) and I(…)

ADWC – the hidden gem: Zepplin Notebook

By Franck Pachot . In the previous blog posts I explained how to create, and stop/start the Autonomous Data Warehouse Cloud service. And I didn't show yet how to connect to it. It is(…)

ADWC – a Docker container to start/stop Oracle Cloud services

By Franck Pachot . In the previous post, I've explained how to start and stop the Autonomous Data Warehouse Cloud service from PSM (PaaS Service Manager). There's a setup phase, and a run phase starting with(…)

ADWC: start/stop with PSM Command Line Interface

By Franck Pachot . In the previous post, I explained how to create an Autonomous Data Warehouse with PSM (PaaS Service Manager Command Line Interface). The most common operation you want to do with it is(…)

ADWC: Creation of Autonomous Data Warehouse Cloud service

By Franck Pachot . You want to try the Autonomous Data Warehouse Cloud Service? That’s easy. Here is a Step-by-Step. Cloud Credits First, you need Cloud Credits. You may have bought them (any recent negotiation with(…)