Data Pump allows creating export files in a directory of your choosing. In this video, learn how to use the CREATE DIRECTORY command to create a directory object for Data Pump and how to use the expdp DIRECTORY parameter to specify the target directory during an export.
- [Instructor] When exporting data using Data Pump,…we can choose the directory in which our export file…will be created.…However, we don't actually specify…the full file system directory path…as part of our EXPDP command line,…but instead, first create a directory object in…the Oracle database, give it an alias,…assign that directory object to a file system directory…and use the name for that directory object…in our EXPDP command line.…
Sounds complex, well it's actually easier than you think.…Let's see an example and it will all make sense.…We will start by connecting to our Oracle database using…the system user.…So SQL plus system and the password,…which in our case is oracle.…This will of course change in each Oracle database.…Now that we're connected to our Oracle database,…we'll create a new directory object,…by typing create, directory, and give it a name,…say my underscore EXP underscore dir one,…as you can tell we are very very creative…in our directory naming, and type as…and within quotation marks specify…
- 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.