(Jim Czuprynski) When an Oracle database suddenly becomes unavailable, the immediate reaction is to do something — right now! — to solve the problem, which sometimes makes the problem worse. This article discusses some examples of when it’s really best to stop and think before proceeding.

This document describes the tasks to install Oracle Database 10g Standard Edition on a Windows two-node cluster, using Real Application Clusters (RAC) and Automated Storage Management (ASM). This install also builds a general purpose starter database with the Sample Schemas included and with automat

(Mark Rittman and Jon Mead) Oracle Express has for many years been the industry’s leading OLAP server, offering unparalleled functionality, query performance and application support. With Oracle9i, Oracle has taken the best features of Oracle Express and embedded them in the database kernel. By

(Marcin Policht) One of the most interesting phenomena in the computing arena within the last few years is the growing concern for security, which, at this point, is being treated on a par with efficiency and cost (as a matter of fact, security became one of the primary factors when evaluating any t

(Haidong Ji) Most of us work with and specialize in only one RDBMS system, such as MSSQL, Oracle, or IBM DB2. However, increasingly, we find outselves dealing with a heterougeous database environment and are asked to solve data interoperability problems. Although the major RDBMS vendors try to fo

Data warehouses have become a cornerstone of successful enterprises, and many companies are recognizing that they can further leverage their data warehouse investment by using the information in the warehouse to more effectively drive day-to-day business operations. The traditional role of a dat

(Mark Rittman) I had an interesting question put to me at work yesterday, where a colleague was having problems with an outer join in an SQL statement. My collegue was putting together as system that recorded bids for contracts, storing the userid of the system operator, the details of the prospe

(Philip Greenspun) When representing date-time information in Oracle it becomes absolutely critical to know with which version of the Oracle server you are working. From version 9 onwards it is possible to represent points in time and time intervals using ANSI SQL data types such as timestamp and in

(Navroz Kapadia) This script will generate a SQL*Loader control file for any specified table, which can then be customized as per individual needs. Ensure it is run by a user with SELECT_CATALOG_ROLE. Parameter 1 is the owner of the table. Parameter 2 is the tablename.

In Oracle, several kinds of (clustered) indexing are supported. This page briefly explains the SQL DDL statements that can be used to setup (clustered) indexes.