BE SHARING

Tablespaces

Can I do it with PostgreSQL? – 3 – Tablespaces

25.11.2016 by Daniel Westermann

In the last posts of this series we talked about restore points and how you could do things that would require the dual table in Oracle. In this post we'll look at tablespaces. This(…)

Database management

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

05.08.2013 by Oracle Team

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

Database management

Wie kann ich Indexes und Daten mittels Data Pump trennen?

18.02.2013 by Jérôme Witt

Diese Frage habe ich in den letzten Jahren öfters gehört. Zumindest seitdem die DBAs Oracle Datapump verwenden anstatt des alten Export/Import Tools. Angeblich war es früher mit dem Import-Parameter-Tool „INDEXFILE“ viel einfacher. Tja, die Wahrheit ist: Mit Datapump geht es noch(…)

Database management

Oracle space management & recycle bin

04.08.2011 by Yann Neuhaus

This post describes some basic Oracle database management issues database administrators might be confronted with. It is about space management and differences observed while monitoring the available space from several point of views (tablespace/datafile) in Grid Control 11g. It also(…)

Database management

DBMS compression: determining a table’s compression ratio

01.03.2011 by Oracle Team

According to the Oracle documentation, the dbms_compression procedure allows to determine the compression ratio for a table without creating it. Let's have a look at it.

Hardware & Storage

Oracle Basics (2) – Data Storage

31.01.2011 by David Hueber

What is finally the primary objective of a database? Storing Data The question is, how Oracle makes it. For many beginners a confusing topic isto get the picture between physical storage and logical one. So how does it(…)