ORACLE

Upgrading to Oracle Database 10g

Wednesday, 10 June 2009 11:58 Huseyin Bilgen

This article provides a brief overview of the areas involved in upgrading existing databases to Oracle 10g Release 1. The article provides the minumum information needed when preparing for the 10g Database Administation OCP upgrade exam, including:

Supported Upgrade Paths
Pre-Upgrade Validation Checks
Database Upgrade Assistant (DBCA)
STARTUP UPGRADE

The whole migration process is beyond the scope of this article so please refer to the Upgrading a Database to the New Oracle Database 10g Release document for further information.

Add comment (0)

Netbackup-Redirecting a Restore to a Different Client

Sunday, 31 August 2008 11:47 Huseyin Bilgen

You have the option to restore an SAP database to a client other than the one that originally supplied the backup. This process of restoring data to a different client is called a redirected restore.

Add comment (0)

Re-Creating PSAPTEMP on Oracle

Sunday, 31 August 2008 11:42 Huseyin Bilgen

Following procedure helps you to re-create Temporary Tablespace PSAPTEMP while system is running.

Add comment (0)

Effective Optimizer Statistics Update

Sunday, 31 August 2008 11:35 Huseyin Bilgen

Following command is very effective, as its not estimating, doing a real calculation on tables including all indices to find the right path for R3 Systems.

Add comment (0)