HP’s Oracle Blog

Notes of a Junior on the Path to Oracle Mastery


Notes of a Junior on the Path to Oracle Mastery
On this blog I am writing about thoughts, solutions, failures and pitfalls on the path to Oracle Mastery. It’s still a long way to go. On this blog, the main focus is learning Oracle.

Materialized View Replication

Published by HP Fuchs | Filed under Oracle Database, PL/SQL

This post is for my friend Gerry, who - as a newby to Oracle - has to support a replicated environment. Gerry is my successor at Kanton Luzern. Management didn’t look for a new DBA because they said it’s hopeless to find somebody. Instead they decided to give somebody inhouse the opportunity. Gerry is highly [...]

February 6th, 2008. 10 Comments »

Killing Oracle Sessions of a User

Published by HP Fuchs | Filed under Oracle Database, PL/SQL

We are hosting around a hundred websites for the public administration on a web content management system which is built on top of an Oracle database. There is a stage and a live environment with snapshot replication. Sometimes websites on the live environment have to be dropped and recreated. One website is represented by one [...]

March 8th, 2007. Comment now »

Nightly Full Export Without Showing SYSTEM Password Using Data Pump

Published by HP Fuchs | Filed under Oracle Database, PL/SQL

In addition to RMAN backup I have a full export batch running every night on all databases. The SYSTEM password has been kept in the batch script. Whoever can logon to the system and read the file knows the SYSTEM password.
In 10g with DBMS_DATAPUMP called from a simple PL/SQL package I can schedule the nightly [...]

September 19th, 2006. 3 Comments »