• Database down! Bring it back alive!

    This excerpt from "Everyday Oracle DBA" explains what to do in the event that your database goes down and you're under pressure from your managers to get it back up as soon as possible.  Continue Reading

  • A bit wiser with Oracle technology

    Learn how to use a metadata repository to identify a "source of truth" for each customer attribute in a data warehouse. This tip explains how to use the base-two numbering values of the primary key in the data source reference table and bitwise ...  Continue Reading

  • Recovering from user errors

    This book excerpt explains how to recover a dropped table using Flashback technology, manage the recycle bin, perform a Flashback Table operation, recover from user errors using Flashback Versions Query and perform transaction-level recovery using ...  Continue Reading

  • Recover Oracle databases

    This book excerpt explains how to recover from the loss of a controlfile, redo log file or system-critical or nonsystem-critical datafile.  Continue Reading

  • Introduction to BPEL

    It's important for managers, developers and DBAs to have an understanding of how BPEL can benefit them. This article provides an introduction to BPEL including Oracle's BPEL Process Manager.  Continue Reading

  • SQL puzzles and answers: Finding equal sets

    A SQL puzzle in the December 1993 issue of Database Programming & Design magazine was to use a supplier and parts table to find pairs of suppliers who provide exactly the same parts. This is the same thing as finding two equal sets. How many ...  Continue Reading