matthias – Seite 2

Cloning Schema with Data Pump

Here is one quick example how to clone one schema within a Oracle database. The most easiest way is to use data pump. My hint will have also the

In your organisation the storage growth of your database could be an important topic. Storage becomes cheaper and cheaper but there is no room

In my last project I had to create a merge statement which should insert or update rows in dependency of the source data. The behavior of the

Dynamic Actions making the difference! This marketing slogan belongs to the fact that the quality and usage of dynamic actions in your

Last week I’ve faced an issue with a full Fast Recovery Area. The main cause was that an application script ran “amok”, lots of

Sometimes I have a request to search within a table find out for example when a server delivered his data last time. Here some sample data. As

Since Oracle Database 11g Release 2 there is a feature called “Instance Caging” managing and limiting the number of CPUs used by a

I’ve faced the task to create a daily job which generates a CSV-files and store it for an an indefinite period in a table. As you know

This is my first blog post. This blog will deal with several topics about the Oracle universe. As you maybe noticed from the blog heading, most