Data movement course
Data movement course
Oracle Database,Oracle,Oracle Other
Lectures -65
Resources -11
Duration -7.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Practice makes perfect! Master data pump utility by performing different hands-on lab scenarios with this course
Oracle data pump tool boosts the migration of data and metadata from the source database to the destination database. It is also the most widely used utility in oracle database for data copy, refresh, etc, and also used in cloud migrations. So learning this tool help you in your career.
Goals
This course is for oracle learners who want to learn data pump utility in oracle for performing different methods of data copy and refreshing data
In this course, learners will perform hands-on tasks as if in a real-time scenario with different situation-based tasks
All the parameters will be used in the practical box for different oracle versionsÂ
Oracle machine is built in virtual box for simulation of the tasks
Learners can be able to confidently face a request from the application team after completing the course
Datapump is the core of this course. So only the data pump utility will be explained
Prerequisites
- Linux operating system basics
- PC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bitÂ
- CPU core(minimum) - 2
- Student category: Linux
![Data movement course Data movement course](https://d3mxt5v3yxgcsr.cloudfront.net/courses/7265/course_7265_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
1 Lectures
-
Course Introduction 02:13 02:13
Install OEL 7.8
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Configure Oracle prerequisites
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Install Oracle database 12c
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Basics
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
VM clone for setup
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Monitor Datapump
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Trace datapump jobs
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Parfile for datapump command standards
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Start,Stop,Resume and Kill datapump jobs
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Export Data across multiple dumpfiles
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Estimate dumpfile size
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Spread dumpfiles across disks
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Datapump Scenarios
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Locking issues during export/import
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Monitor progress for each object type
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Load data through network
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Master table analysis
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Compression levels
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Configure NFS mount
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Datapump parameters in RAC
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Consistent backup
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Logfile exclude
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Access methods
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
User definition backup
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Objects definitions in a SQL file
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Export Samples of data
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Query filter using expdp
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Data Obfuscation
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Archivelog disable during import
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Optimize datapump
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Limit parallel worker at database level
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![user profile image](/market/public/assets/newDesign/img/default-user-img.jpg)
Kishan m
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)