Database management

Oracle Database 12c: PDBs not fully transportable yet

One of the benefits of the new Oracle multi-tenant database option is to create a kind of cloned environment through simple statements. This post will focus on the creation of pluggable database through a database link. The reason of(…)

Oracle Database 12c: SecureFiles enhancements

Oracle Database 12c features with some enhancements for LOB objects and particularly for the SecureFiles. This is not a revolution, but we can see that the range of possibilities with LOB objects increases with the different releases of Oracle…(…)

Oracle Database 12c new features: segregation of duties with new administrative roles

Starting with Oracle Database 12C Release 1 a set of new administrative privileges that are more task oriented are available.Before Oracle 12c it was needed to have the SYSDBA privilege to make a backup, to monitor the Data(…)

Oracle Database 12c: Partitioning enhancements Part I – Reference partitioning

Oracle Database 12c offers several enhancements for partitioning. This blog posting will present some enhancements in relation to reference partitioning. The differences between the Oracle 11g R2 and Oracle 12c releases will be shown using practical examples. TRUNCATE and(…)

Data Pump in Oracle Database 12c: die wichtigsten Neuigkeiten

Letztes Jahr hat Oracle CEO Larry Ellison während der Oracle OpenWorld in San Francisco ein neues Datenbank Release angekündigt, das nun endlich zur Verfügung steht. In diesem Blogbeitrag möchte ich einige der wichtigsten Data Pump-Neuigkeiten vorstellen. Eine komplette Übersicht(…)

Errors while installing Oracle Database Vault on Oracle 11.2.0.3

During one of my last consulting missions, I had to install Oracle Database Vault on an existing Oracle environment. It clearly was not a straigthforward process, since I experienced some weird errors such as: ORA-28003: password verification for the specified(…)

Oracle Database 12c: Binary installation

Introduction   The aim of this blog is to present you the Oracle 12c Binary Installation with some of the preinstallation tasks. 12C Disk Space for(…)

Oracle 12c Backup & Recovery: What’s new?

After months of waiting, Oracle Database 12c is finally available. In this posting, I am going to provide a summary of the new features of Oracle 12c in terms Backup and Recovery. Pluggable, what else? For sure, the most(…)

SQL Server 2014: AlwaysOn-Verfügbarkeitsgruppen – jetzt mit Microsoft Cloud!

SQL Server 2014 bietet jetzt (oder bald :roll:) die Möglichkeit der Integration von AlwaysOn-Verfügbarkeitsgruppen mittels virtueller Maschinen, gehostet in der Windows-Azure-Infrastruktur (IaaS). Sie können sekundäre Datenbanken direkt in der Cloud vorhalten, wie das Beispiel zeigt:(…)

Oracle Database 12c: Moving a datafile is now possible online

Gone are the days where you had to put a tablespace or your complete database offline in order to move or rename a datafile. Oracle 12c features a new command that allows to move datafiles when both database and(…)