(Jayaram Krishnaswamy) In a previous article, a set of tables from Oracle 10G XE were transferred to SQL 2005 Server using SQL 2005 Server’s Export/Import Wizard. This article is about migrating a table from Oracle 10G XE to SQL Anywhere 10.

(Tarry Singh) I keep getting offers all the time–contracts in which I have to install databases (RAC or Standard) for clients. Every time, I have to go through the rigmarole of preparing and then installing the database. It is good, it pays me well per hour, but is it smart? I don’t think so. VMwar

(David Baum) Oracle Magazine spoke with Noel Yuhanna, a senior analyst covering database technologies at Forrester Research, about new trends in enterprise grid management

Hints are comments embedded in SQL that can help influnce the behaviour of the Cost Based Optimizer.

(Scott Stephens) In Oracle 10g, exp and imp have been redesigned as the Oracle Data Pump (although Oracle still ships and fully supports exp and imp). If you’re used to exporting exp and imp, the Data Pump command-line programs have a syntax that will look very familiar.

(Sreeram Surapaneni) Every DBA needs to know how to do their work under pressure, while facing crisis after crisis. Our most important contribution is to keep the database running. It’s an on-call function; you never know what might happen. Half the branch was up all night last night restoring a dat

(Alf Pedersen) Oracle partitions addresses the key problem of supporting very large tables and indexes by allowing you to decompose them into smaller and more manageable pieces called partitions. Once partitions are defined, SQL statements can access and manipulate the partitions rather than enti

(Caleb Small) Transportable Tablespaces are the most efficient way to move large amounts of data from one Oracle database to another. When combined with a properly designed table partitioning scheme this feature provides an ideal method of refreshing a data warehouse or archiving transactional data

(Steve Lemme) At the top of business executives’ minds today is how to meet new regulatory compliance and corporate governance rules. New laws are changing the way companies collect, retain and manage information. DBAs need to understand what is happening in the corporate business world and how it w

(Lewis R Cunningham) This is part 2 of a series on learning PL/SQL. If you are new to PL/SQL, you should read part 1 first. Also, check out the Article Index.