Expanded Library

Moving Data with Oracle

by Agaba Philip

Moving data in and out of Oracle is a very common task performed by DBAs and developers. In this course, you will learn how to properly deploy these essential tools.

What you'll learn

In this course, Moving Data with Oracle, you will learn how to work with Data Pump, SQL Loader, and External Tables.

First, you'll start by creating directory objects and use SQL Loader to load data from non-Oracle sources.

Next, you'll explore external tables, which allow us to access operating system files from within Oracle.

Finally, you'll learn to use Data Pump to move data between Oracle sources.

By the end of the title, you’ll be able to move data in and out of Oracle, and you’ll be able to do it efficiently, using the best tool, for the job.

About the author

I got my start in IT administrating an Oracle 10g database on Red Hat Linux. I've come a long way since and have used Linux everyday since 2012 both personally and professionally. As an independent consultant, I'm currently responsible for no less than forty Oracle databases running on Windows and Red Hat Servers. Perhaps the only thing I love almost as much as Linux is the Cloud and the many opportunities it provides. Linux has opened a lot of doors for me, and teaching it is my favorite pas... more

Ready to upskill? Get started