Tips

Tips

Oracle database export, import and migration

• Seven to-do items for managing an Oracle cloud migration

  Migrating Oracle systems to the cloud is a big initiative for any organization. Make sure you put a solid migration plan in place to help ease the transition and keep it on track.  Continue Reading

• Migrate an Oracle RAC database to new servers with zero downtime

  Most organizations can't afford any downtime on their Oracle systems. Here's how to move RAC databases to new server nodes and still stay up and running in an Oracle cluster.  Continue Reading

• Addressing quality-of-service improves Oracle database consolidation

  In this fourth installment of a series on Oracle database consolidation, Jeff McCormick writes about achieving multi-tenancy within Oracle Database by addressing more quality-of-service concerns.  Continue Reading

• How to copy an Oracle database

  Contributor Raymond Lefebvre, a database director, explains how to do one of the most common things DBAs are required to do – copy an Oracle database.  Continue Reading

• Oracle and SQL Server: BFF?

  An overview of some of the new and old ways to successfully exchange data between Oracle and SQL Server 2005 instances.  Continue Reading

• Oracle as data integrator

  Oracle as data integrator  Continue Reading

• Guide to Oracle freeware and shareware

  This list of free and low-cost tools and utilities will help Oracle DBAs and developers do your job better.  Continue Reading

• Upgrading Oracle: Linux vs. Windows

  An ITKnowledge Exchange member asked about moving Oracle from RISC/Unix to either Windows or Linux, and fellow techies jumped in on the conversation.  Continue Reading

• Speed up data transport between primary and standby database

  Speed up data transport between primary and standby databases in a DataGuard environment.  Continue Reading

• Reducing the amount of space used during exports

  This Oracle tip shows how to reduce the amount of space used during exports.  Continue Reading

• Secure import/export user

  Avoid the security problem of putting passwords in script files for privileged users.  Continue Reading

• Compressing Oracle exports on the fly

  Here is how to create compressed Oracle export files on the fly.  Continue Reading

• Monitor the import or export of an Oracle database

  A script that will allow a DBA to see how many rows were imported or exported and is especially useful with big tables.  Continue Reading