In addition to supplying Data Pump with configuration parameters at runtime, you can also create a parameter file containing the export or import specifications and use it as part of your Data Pump job. In this video, learn how to create a parameter file and reference it using the PARFILE parameter as part of your Data Pump expdp or impdp usage.
- [Instructor] Data pump export and import…both support the usage of parameter files.…Using a data pump parameter file…is done instead of manually supplying…each and every individual data pump configuration parameter…via the command line…to the exdp or imdp data pump utilities.…This method of using parameter files…can also help…if you wish to run scheduled export or import jobs…on a regular basis…and store the configurations options…for these jobs in a text file…which can be reused across different export…or import jobs,…so let's see an example of using a data pump parameter file…as part of an export process.…
We'll start by creating our parameter file.…In order to create our parameter file,…I'm going to use the Linux VI text editor,…so I'm typing vi and the path…where I want the parameter file…to be created,…so I'm going to type /home/oracle/export.par.…You can of course choose any name…and any location you want.…Pressing enter will create the parameter file…and open the VI text editor.…
Here we can supply all of the command line arguments…
- 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
Learning Relational Databases (2014)with Adam Wilbert2h 39m 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.