All articles

Run SQL Server everywhere!

Running SQL Server everywhere is not a dream anymore!  Microsoft has just announced the first release of SQL Server CTP1 on Linux today! But that’s not all! SQL Server Vnext is also available on Windows,(…)

12cR2: CREATE_FILE_DEST for PDB isolation

By Franck Pachot . Two years ago I filled an OTN idea to 'Constrain PDB datafiles into specific directory' and made it an enhancement request for 12c Release 2. When you provision a PDB, the PDB(…)

Managing My Amazon Web Services Redhat Instance

By Mouhamadou Diaw In a precedent Blog I talked about how to create an AWS linux instance. Some questions can be: How to create a new user and to connect with, how to transfert files from my(…)

Linux Instance in Amazon Web Services (AWS)

By Mouhamadou Diaw In this article I will talk about how to create a linux machine in the cloud amazon AWS. For testing a trial account can be created. Once registered, we can connect by using(…)

12cR2 Single-Tenant: Multitenant Features for All Editions

By Franck Pachot . Now that 12.2 is there, in the Oracle Public Cloud Service, I can share the slides of the presentation I made for Oracle Open World:(…)

12cR2 new index usage tracking

By Franck Pachot . A common question is: how to know which indexes are not used, so that I can drop them. If you tried to use index monitoring you probably have seen the limits of it which make it(…)

12cR2 has new SQL*Plus features

By Franck Pachot . 12cR2 is there. What's new in SQL*Plus? For sure, you can't expect lot of things from it. The new command line is the SQL*Developer sqlcl which aims to be 100% compatible with SQL*Plus with lot of(…)

Documentum – Cannot delete document due to VD/assembly references

I went into an error that you might already have once, so here is a quick guide on how to fix it. When deleting a document from D2 I had a popup with an error like: Cannot delete file because(…)

Oracle 12cR2: MAX_PDBS

By Franck Pachot . Oracle database 12.2 is there on the Database Cloud Service, in multitenant. In EE High Performance or Extreme Performance, you have the multitenant option: you can create 4096 pluggable database (instead of 252 in 12.1). If(…)

Oracle 12cR2: Pluggable database relocation

By Franck Pachot . Here is, in my opinion, the most beautiful feature of the multitenant architecture. You know how I love Transportable Tablespaces. But here: No need to put the source in read/only No need to export/import the metadata(…)