Summary
In this chapter, we've examined the many ways we can migrate database data in Oracle. We've explored how external tables can be created to read data directly from an external file. We've examined the SQL*Loader tool and used it to read data from an external file and load it into the database. Finally, we've used Oracle's Data Pump to export data from and import data into database tables, as well as examining a number of Data Pump's transformational features.
Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide 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.
