Further reading
- Oracle Cloud Infrastructure Database Migration (DMS): This provides a step-by-step guide for offline logical migration, available here:
https://www.oracle.com/a/ocom/docs/oci-database-migration-onprem-adb.pdf
- Oracle Database Migration Methods: Learn the different ways to move an Oracle database by Arun Kumar: This provides a summary of Oracle database migration methods using Oracle RMAN and Oracle Data Pump.
- Expert Oracle Database Architecture: Techniques and Solutions for High Performance and Productivity by Darl Kuhn and Thomas Kyte: Chapter 15 of the book deals with the data loading and unloading methods and provides an interesting discussion about identifying and dealing with errors, as well as best practices to optimize the data loading and unloading process.