Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Posted Oct 27, 2003

Steve Callan

By DatabaseJournal.com Staff

Steve is an Oracle DBA (OCP 8i and 9i)/developer working in Denver. His Oracle experience also includes Forms and Reports, Oracle9iAS and Oracle9iDS. Steve's Hotmail email address is stevencallan@hotmail.com.

Current Articles

Creating Dump Files in Oracle GoldenGate
Getting Started with Oracle GoldenGate
Oracle Database Replication: Streams vs. GoldenGate
Fundamentals of Oracle GoldenGate
Oracle DBA: 5 Technologies You Can't do Without
How to Install the Oracle Enterprise Manager Grid Control Component
Installing the Oracle WebLogic Server Component
Introduction to Oracle Enterprise Manager 11g
Connecting to SQL Server from Oracle Database
Oracle APEX: Doing More with Less
Book Review: Oracle SQL by Example
Oracle Database: Flashback Vs. Recovery
The Old and New of Oracle Business Intelligence
What's New in Oracle Warehouse Builder
Examining the Oracle Database 10053 Trace Event Dump File
Purchasing Oracle Database Support for your Own Use
Installing Oracle Database Sample Schemas using Data Pump
PL/SQL Records for Oracle Database Administrators
Setting Up Oracle Database's Oracle Text
Oracle Text - Expanding Your String Searching Capabilities in Oracle Database
SQL Server Management Features vs Oracle Database Management Features
Mapping SQL Server Management Features to Oracle Database
Mapping SQL Server Features to Oracle Database
Oracle Database to SQL Server Comparisons
Oracle DBA Job Interview - Nailing a Fairly Common Question
Configuring Oracle as a Data Source for SQL Server
Building an Oracle (and other RDBMS) Server Environment
Setting up Oracle as a Data Source for SQL Server
Oracle as a Data Source
To Partition or Not to Partition in E-Business Suite
Printing Barcodes in Oracle Reports
More Advanced Features of Toad for Data Analysts
Product Review: Toad for Data Analysts
Protecting Data from Users
Oracle's Block Browser and Editor tool
SQL Performance Analyzer
Installing Oracle Block Browser and Editor tool (bbed)
Compressing files in Oracle
RMAN TSPITR - Examining the driver script
RMAN Drills
Course Review: Performance Optimization for Developers by Hotsos
Monitoring Databases
VMware and Oracle Setup Examples - Part 2
VMware and Oracle Setup Examples
Revisiting Oracle Passwords
Oracle on Windows, Revisited
Connecting Oracle BI Publisher to SQL Server
A Mirror between Oracle and SQL Server
What's in an Oracle Schema?
Changing the Word Size in Oracle
Oracle Support Notes - "Complete Guides" Usually Aren't
Oracle Concepts: Splitting Hairs
Multilingual linguistic searching and sorting in Oracle
Sorting Strings in Oracle
Searching and Sorting Strings in Oracle
Joining Disparate Data in an Oracle Database
Hidden treasures in Oracle's STATSPACK utility
Optimizer Hints in Oracle 11g (and hint overkill)
Free Hands-on Oracle E-Business Suite Training
Installing Oracle E-Business Suite R12 on Windows 2003
Business Intelligence Publisher - The "Other" Oracle Reports
Oracle Reports for DBAs
Hands-on Oracle: Backup and Recovery Games - Creating Datafiles
Product Review - Toad Data Modeler 3
Oracle Applications Reference Books
Oracle DBA in an Oracle Applications World - Part 2
Oracle Warehouse Builder Automated ETL Processing
Oracle DBA in an Oracle Applications World
Recovering from Loss of All Control Files
Licensing and Auditing in Oracle
Hands-on Oracle: Backup & Recovery Games
Cascading in Oracle: Friend or Foe?
Keywords in Oracle
Managing Oracle's Undo Tablespaces
More on Using Tools for Tracing
RMAN Tablespace Point in Time Recovery
Oracle Tuning Using Tracing, STATSPACK, AWR and Toad
Saving Time by Reusing Storage
Product Review: Oracle PL/SQL Tuning
Hashing in Oracle
Transportable Tablespaces: Why the Platform Matters
The Dictionary in the Data Dictionary
Making Database Administration Easier with Freeware
Clearing Alerts in Enterprise Manager
Learning Oracle by the Numbers
Spicing-up Oracle on Windows
Getting Inside the Optimizer - Part 2
Getting Inside the Optimizer
Partition Pitfalls in Oracle
Serving up Server Alerts
Row Movement in Oracle
Quest Code Tester for Oracle
Multipurpose code in Oracle and Oracle Forms
Data Manipulation Using Java in Oracle
Ordering Events in Oracle
Oracle: Sorting Out Memory
Getting a Handle on Indexes
Review: Oracle Performance Tuning for 10gR2, Second Edition
Product Review: EMS SQL Manager
Using SQL Developer to Learn Oracle
Hackers in your Database
Quest Software and Toad for Oracle
Oracle: Choosing and Using the Right Code
How Advances in Storage Technology Create a New Security Challenge
Oracle after Hours: Gathering Statistics
Book Review: Expert Oracle Database 10g Administration
Managing Tables: Logging versus Nologging
Oracle DML Error Logging
Interview Tips for Aspiring Junior DBAs
Tips and Tricks for Oracle in a UNIX World
Oracle: Separating Numbers and Letters
Types of Tables in Oracle
How Does Oracle Perform Math?
Finding and Setting SQL*Plus Settings
Rolling Back Layers of Automatic Undo Management
Controlling Backups with Database Control
Combining Overloading and Session Management in Oracle
Trees and Hierarchies in Oracle
Database Migration - It's More than Running exp and imp
Database Migration - A Planned Approach
Project Raptor - Oracle's New Tool for DBAs and Developers
Database Security and Patches - Part 5
OC4J - The "Other" Oracle Application Server
Database Security and Oracle Patches - Part 4
Database Security and Patches - Part 3
Database Security and Patches - Part 2
Database Security and Patches - Part 1
Reviewing Views
Oracle Performance Tuning - Part 3
Oracle Performance Tuning - Part 2
Oracle Performance Tuning - Part 1
Database Modeling Using Visio
Making the Case for CASE Tools
Oracle on the Web Part 5 - More on HTML DB
Where Did Oracle Come From?
Oracle on the Web, Part 4 - Upgrading HTML DB
Oracle on the Web - Part 3 - Using Applications in HTML DB
Oracle on the Web, Part 2 - Oracle 10g's HTTP Server and HTML DB
Using LogMiner - Part 2 - Striking Out
Oracle on the Web Part 1 - Exploring Oracle's HTTP Server
Doing Data Guard - Part 2
Oracle and Pro*C - Part 1
Connecting with Oracle - Ensuring Sufficient Privileges
Doing Data Guard - Part 1
Database Benchmarking
Describing Oracle Syntax
Oracle Migration Workbench - Part 5
Oracle Migration Workbench - Part 4
Product Review: Thomson Course Technology's Oracle9i Database Performance Tuning
Oracle Migration Workbench - Part Three
Oracle Migration Workbench - Part Two
Oracle Migration Workbench - Part 1
Oracle Response Files - Part 2
Installation Cookbooks: Deploying Reports on the Web
Installation Cookbooks: Deploying Forms on the Web
Oracle Response Files - Part 1
Connecting with Oracle: The Password Game
Oracle Administration - Part 2
Oracle Administration - Part 1
Oracle's Wrap Utility
Oracle Performance Tuning - (Otherwise Known as Drowning in a Pool of Confusion)
Oracle on Windows Part 3 - The Registry
Oracle Certification - The Last Word on OCP for Oracle8i
Striking Gold with LogMiner - Part 1: Getting Started
Oracle's Sample Schemas: Saying Goodbye to Scott
Connecting with Oracle: Accessing Oracle via Access and Excel
So You Want to Become an Oracle DBA? Part 2 - Learning Oracle on your own
Unwrapping Oracle's DBMS Packages: Understanding Oracle's Random Number Generator
Connecting with Oracle: Oracle Ports
So You Want to Become an Oracle DBA? Part 1 - Getting Close to Oracle
Oracle on Windows - Part 2
Using Oracle's SQL Functions - Part 2
Installation Cookbook: Installing Oracle Application Server 10g (9.0.4)Forms and Reports Services
Using Oracle's SQL Functions
Installation Cookbooks: Installing Oracle9i Developer Suite
Oracle on Windows
The Trigger-Happy DBA - System Triggers
Installation Cookbooks: Installing Oracle Forms & Reports 6i
Installation Cookbooks: Installing Oracle9i
The Trigger-Happy DBA - Part 2
The Trigger-Happy DBA
Connecting with Oracle: Finding and Setting a Configuration File Location
Connecting with Oracle

Series Articles

Comparing SQL Server and Oracle Database Features

Hands-on Oracle: Backup and Recovery Games

Oracle DBA in an Oracle Applications World

Database Migration - A Planned Approach

Database Security and Patches

Oracle Performance Tuning

Oracle on the Web

Oracle Migration Workbench

Oracle on Windows

Installation Cookbooks

Trigger-Happy DBA

Connecting with Oracle