Home DATABASES
test text

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.
Read more
Add comment (0)
Hits: 1505
 

Create Non-Clustered Index on MSSQL

Tuesday, 09 June 2009 12:40 Huseyin Bilgen
User Rating: / 2
PoorBest 

Normally, when you try to create Non-Clustered Index on MSSQL Server Platform, SE14 gives errors

Read more
Add comment (0)
Hits: 1451

DB2: Update all database statistics with a single command

Sunday, 31 August 2008 11:53 Huseyin Bilgen

As with all RDBMS implementation, DB2 UDB uses the statistics information in the catalog table to derive the best execution plan. We, as DBAs, should regularly run the RUNSTATS command to keep our database statistics updated for optimal query performance.

Read more
Add comment (1)
Hits: 5071

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.

Read more
Add comment (0)
Hits: 7378

Re-Creating PSAPTEMP on Oracle

Sunday, 31 August 2008 11:42 Huseyin Bilgen
User Rating: / 5
PoorBest 
Following procedure helps you to re-create Temporary Tablespace PSAPTEMP while system is running.
Read more
Add comment (0)
Hits: 4572
  • «
  •  Start 
  •  Prev 
  •  1 
  •  2 
  •  3 
  •  Next 
  •  End 
  • »
Page 1 of 3