Email Alerts
-
Oracle database upgrade guide
If you’re considering a move to a new Oracle database version -- especially Oracle Database 11g or Oracle Database 11gR2 -- read our Oracle database upgrade guide for tips and customer success stories. Tutorial
-
Oracle upgrades: Tips and trends
If you’re planning an Oracle upgrade, start here to learn about the latest Oracle upgrade trends. Also, get expert advice from Oracle gurus and learn about the current state of Oracle Fusion Middleware upgrades. Tutorial
-
Oracle data export guide
Exporting data is a common task for an Oracle DBA, but not necessarily a straightforward one. In this compliation of questions and answers, SearchOracle.com's resident Oracle experts Eli Leiba, Karen Morton and Brian Peasland explain how it's done, w... Learning Guide
-
Importing into Oracle tutorial
SearchOracle.com's resident Oracle experts Karen Morton and Brian Peasland guide users through some importing tips and techniques, such as how to load text files without SQL*Loader, importing a dump multiple times, importing from different versions, ... Learning Guide
-
One shop describes its move off Oracle on Itanium
Given Oracle’s recent announcement that it would stop software development on Itanium, one environmental services company’s decision to move to x86 Linux is timely. News | 25 Mar 2011
-
Coca-Cola Bottling swaps out Oracle for DB2
Spurred by a deal that would include DB2 with licenses for SAP products, Coca-Cola Bottling Co. decided Big Blue is better than Oracle. Article | 06 Oct 2009
-
Oracle releases new database, says 11g upgrade will cut costs
Oracle released its new 11g R2 database today. But will users embark on an Oracle 11g upgrade? And why should they? Article | 01 Sep 2009
-
EnterpriseDB offers Oracle database users a 'bailout program'
Reacting to Oracle's database price hikes, an open source database vendor unveils a migration program to keep costs down. Article | 04 Aug 2009
-
Author Mike Ault sizes up the new Oracle Database 11g
Oracle book author Mike Ault talks about the upcoming Oracle Database 11g's new SQL replay and memory management capabilities. Article | 03 May 2007
-
Podcast: Oracle Database 11g preview -- New automated features promise to make DBA life easier
Oracle Database 11g will offer new automated management features that should allow DBAs to concentrate on more strategic issues. We talked to an Oracle honcho to find out more. Article | 20 Mar 2007
-
Oracle expert looks ahead to Database 11g
Oracle Database expert Brian Peasland explains why he has little use for the planned XML upgrades in Database 11g and offers advice for DBAs hoping to get certification. Article | 17 Jan 2007
-
Oracle Database 11g to feature XML enhancements
The latest version of Oracle's flagship DBMS offers a host of XML-related upgrades. Article | 12 Dec 2006
-
Podcast: Database guru previews Oracle OpenWorld
Oracle database guru Mark Townsend talks about the highlights of next week's Oracle OpenWorld show. Article | 17 Oct 2006
-
The Oracle Security Challenge
Let's find out what how much you really know about Oracle security. Article | 22 Aug 2006
- See More: News on Oracle database export, import and migration
-
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. Tip
-
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. Tip
-
Oracle as data integrator
Oracle as data integrator Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
Speed up data transport between primary and standby database
Speed up data transport between primary and standby databases in a DataGuard environment. Tip
-
Reducing the amount of space used during exports
This Oracle tip shows how to reduce the amount of space used during exports. Tip
-
Secure import/export user
Avoid the security problem of putting passwords in script files for privileged users. Tip
-
Compressing Oracle exports on the fly
Here is how to create compressed Oracle export files on the fly. Tip
- See More: Tips on Oracle database export, import and migration
-
Exadata, hybrid columnar compression, and inserts
One reader asks Oracle Exadata book co-author Rick Greenwald about compression on row-insertion on Exadata. Answer
-
Server load problems after moving from Oracle 10g XE to 11g SE One
Experiencing server load problems when moving from Oracle 10g XE to 11g SE One? Learn ways to solve these server load issues in this tip from Oracle database expert Brian Peasland. Answer
-
Minimize database downtime when moving an Oracle DB to a new server
Learn how to minimize database downtime when moving your Oracle 10gR2 database from a Windows 2003 32-bit server to a Windows 2008 64-bit server, using the Database Configuration Assistant, in this tip from an Oracle database expert. Answer
-
Oracle backup and recovery strategies: Export dump vs. RMAN
Should you use an export dump or RMAN in your Oracle backup and recovery strategies? Learn about the importance of employing both in this tip from Oracle expert Brian Peasland. Answer
-
Can I run Oracle 9i on a Windows 64-bit O/S?
If you want to migrate Oracle 9i to a Windows 64-bit O/S environment, learn in this expert tip why you may want to install Oracle 10g or 11g first. Answer
-
How to perform Oracle database recovery with a corrupt online redo log
Learn how to perform Oracle database recovery of an Oracle 9i database with a corrupt online redo log with this SYS from Oracle expert Brian Peasland. Ask the Expert
-
How to use the Oracle export utility to duplicate database structure
Oracle expert Brian Peasland explains how to use the Oracle export utility to duplicate Oracle database structure without duplicating Oracle data in this tip. Ask the Expert
-
How to perform an Oracle 8i to 10g migration
Oracle expert Brian Peasland explains how to perform an Oracle 8i to 10g migration when moving to Oracle 10g R2 with these step by step migration tips. Ask the Expert
-
Oracle upgrade process vs. Oracle exp/imp for 9i to 10g migration
Oracle expert Brian Peasland explains the advantages of both the Oracle upgrade process and an Oracle export/import when performing a 9i to 10g migration for a schema in this tip. Ask the Expert
-
Import on one table from dump file
An Oracle user asks if it is possible to do an import on one table from a large dump file. Ask the Expert
- See More: Expert Advice on Oracle database export, import and migration
-
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. Tip
-
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. Tip
-
Exadata, hybrid columnar compression, and inserts
One reader asks Oracle Exadata book co-author Rick Greenwald about compression on row-insertion on Exadata. Answer
-
One shop describes its move off Oracle on Itanium
Given Oracle’s recent announcement that it would stop software development on Itanium, one environmental services company’s decision to move to x86 Linux is timely. News
-
Oracle database upgrade guide
If you’re considering a move to a new Oracle database version -- especially Oracle Database 11g or Oracle Database 11gR2 -- read our Oracle database upgrade guide for tips and customer success stories. Tutorial
-
Oracle upgrades: Tips and trends
If you’re planning an Oracle upgrade, start here to learn about the latest Oracle upgrade trends. Also, get expert advice from Oracle gurus and learn about the current state of Oracle Fusion Middleware upgrades. Tutorial
-
Server load problems after moving from Oracle 10g XE to 11g SE One
Experiencing server load problems when moving from Oracle 10g XE to 11g SE One? Learn ways to solve these server load issues in this tip from Oracle database expert Brian Peasland. Answer
-
Minimize database downtime when moving an Oracle DB to a new server
Learn how to minimize database downtime when moving your Oracle 10gR2 database from a Windows 2003 32-bit server to a Windows 2008 64-bit server, using the Database Configuration Assistant, in this tip from an Oracle database expert. Answer
-
Oracle backup and recovery strategies: Export dump vs. RMAN
Should you use an export dump or RMAN in your Oracle backup and recovery strategies? Learn about the importance of employing both in this tip from Oracle expert Brian Peasland. Answer
-
Can I run Oracle 9i on a Windows 64-bit O/S?
If you want to migrate Oracle 9i to a Windows 64-bit O/S environment, learn in this expert tip why you may want to install Oracle 10g or 11g first. Answer
- See More: All on Oracle database export, import and migration
About Oracle database export, import and migration
In this section, you can read through tips and advice on importing, exporting and migrating Oracle data between Oracle databases and elsewhere, including help with upgrades and cross-platform migrations.