From the course: Oracle Database 12c: Backup and Recovery

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Importing data using Data Pump

Importing data using Data Pump - Oracle Database Tutorial

From the course: Oracle Database 12c: Backup and Recovery

Start my 1-month free trial

Importing data using Data Pump

“

- [Instructor] Now that we have successfully performed our first data pump export, it's time to see how we can import the data back into our Oracle database. Remember that the data pump expdp command creates a binary file containing the objects and table we exported from the database. This file is portable, and we can use it to import the data back into any compatible Oracle database. The Oracle source database and target database versions don't even have to match. This makes data pump very useful for cross database data movement, export data from one Oracle database, copy the export dump file to another Oracle database, and import the data. Of course you can also import the data back into the same Oracle database from which it was originally exported. Let's see the process in action. First of all, let's perform an export of the demo01 schema from our demo_pdb database. You can find a sample expdp command included in your exercise file. So let's copy the command, and paste it into our…

Contents