O'Reilly logo

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Migrating data with Oracle Data Pump

While SQL*Loader is an excellent tool to load data from an external file, it lacks the ability to offload data for the purposes of populating another database. Historically, standard tools such as Export (exp) and Import (imp) were used for such a purpose. However, as time went on and the needs for transporting data evolved, these tools began to show their age. So, in Version 10g, Oracle introduced a new tool to replace Export and Import – Oracle Data Pump.

Understanding the architecture of Data Pump

Oracle Data Pump is the primary tool used to transport data from one Oracle database to another. It is an extremely effective tool for this purpose, but it is also important to understand its limitations. It is not ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required