O'Reilly logo

Oracle Database XE 11gR2 Jump Start Guide by Asif Momen

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

Chapter 9. Moving Data between Oracle Databases

Pleasure in the job puts perfection in the work. - Aristotle

This chapter describes how to move data from Oracle Database 10g Express Edition to Oracle Database 11g Edition using Oracle's Export/Import utilities. Oracle Database XE supports traditional Export/Import utilities and Data Pump Export/Import utilities. This chapter discusses these approaches in more detail, covering the following topics:

  • Exporting and importing data
  • Traditional Export/Import (exp/imp) utilities
  • Data Pump Export/Import (expdp/impdp) utilities
  • Moving data between Oracle Database 10g XE and Oracle Database 11g XE

Exporting and importing data

Oracle's Export and Import utilities are used to move the data between different machines, ...

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