Oracle 12c

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 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(…)

Oracle Database 12c: Information Lifecycle Management

More and more resources are used in companies to manage data. Most companies buy more and more storage systems because of poor resource utilization. Starting with Oracle 11g, Oracle has introduced Information Lifecycle Management (ILM) which can use different kinds(…)

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(…)

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(…)

Oracle Database 12c: Flashback Data Archive (FDA) – new features

Oracle Database 12c was published in June and among the new features of this release are multiple improvements of the Flashback Data Archive (FDA), an option also known as Oracle Total Recall. In this post, I will present the(…)

Oracle Database 12c: Oracle OEM express

Together with Oracle Database 12c, Oracle has introduced a new administration console named Oracle Enterprise Manager Express (Oracle OEM Express). This “light” version of Enterprise Manager Database Console – which is not supported in Oracle 12c anymore – is a(…)