Data movement course
Data movement course
Updated on Sep, 2023
Language - English
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
What will you learn in this course:
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
What are the prerequisites for this course?
- 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
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
Configure Oracle prerequisites
3 Lectures
Install Oracle database 12c
1 Lectures
Basics
3 Lectures
VM clone for setup
5 Lectures
Monitor Datapump
2 Lectures
Trace datapump jobs
1 Lectures
Parfile for datapump command standards
1 Lectures
Start,Stop,Resume and Kill datapump jobs
1 Lectures
Export Data across multiple dumpfiles
1 Lectures
Estimate dumpfile size
1 Lectures
Spread dumpfiles across disks
1 Lectures
Datapump Scenarios
7 Lectures
Locking issues during export/import
1 Lectures
Monitor progress for each object type
2 Lectures
Load data through network
2 Lectures
Master table analysis
4 Lectures
Compression levels
1 Lectures
Configure NFS mount
1 Lectures
Datapump parameters in RAC
3 Lectures
Consistent backup
1 Lectures
Logfile exclude
1 Lectures
Access methods
1 Lectures
User definition backup
2 Lectures
Objects definitions in a SQL file
4 Lectures
Export Samples of data
1 Lectures
Query filter using expdp
1 Lectures
Data Obfuscation
1 Lectures
Archivelog disable during import
1 Lectures
Optimize datapump
3 Lectures
Limit parallel worker at database level
2 Lectures
Instructor Details
Kishan m
Course Certificate
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
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
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now