images

CHAPTER7

Migrating Oracle Databases with Export/Import

One of the most basic and simplest tools for performing data migrations is Export/Import. The Export/Import tools have gone through several iterations, but all versions essentially perform the same function: extract data from an Oracle database into a binary file, known as the dump file, and load that data into an Oracle database. Legacy Export/Import has evolved into Data Pump Export/Import, but they are essentially the same function, though the latter has some major enhancements. These tools can move data from one database to another but can perform only minor transformations.

Oracle Export ...

Get Oracle Database Upgrade, Migration & Transformation Tips & Techniques now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.