Data Pump provides the capabilities to import data which was exported using Data Pump back to either the same or a different Oracle database. In this video, learn how to use the Data Pump impdp command to import data from a Data Pump export dumpfile into your Oracle database.
- [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 terminal window.…In this command we're opening a connection…
- Complete vs. incomplete recovery
- Point-in-time recovery
- Failure categories
- Preparing the virtual machine
- Performing user-managed backups
- Restoring from manual backups
- Performing full and incremental backups with RMAN
- Recovering a PDB and CDB
- Exporting and importing data with Oracle Data Pump
- Performing logical backups with Data Pump
- Using Flashback Query, Table, and Database
- Creating restore points
Skill Level Intermediate
Oracle 12c Database: Administrationwith David Yahalom3h 58m Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
1. Backup and Recovery Core Concepts
2. Failure Categories and Backup Types
3. Preparing the Course VM
4. User-Managed Backups
5. Recovery Manager (RMAN)
6. Oracle Data Pump
7. Oracle Flashback
What's next?2m 7s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.