Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Data movement course

person icon Kishan M

4.5

Data movement course

Data movement course

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Kishan M

English [CC]

category icon Development ,Database and Design Development,

Lectures -65

Resources -11

Duration -7.5 hours

Lifetime Access

4.5

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

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

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction

1 Lectures
  • play icon Course Introduction 02:13 02:13

Install OEL 7.8

5 Lectures
Tutorialspoint

Configure Oracle prerequisites

3 Lectures
Tutorialspoint

Install Oracle database 12c

1 Lectures
Tutorialspoint

Basics

3 Lectures
Tutorialspoint

VM clone for setup

5 Lectures
Tutorialspoint

Monitor Datapump

2 Lectures
Tutorialspoint

Trace datapump jobs

1 Lectures
Tutorialspoint

Parfile for datapump command standards

1 Lectures
Tutorialspoint

Start,Stop,Resume and Kill datapump jobs

1 Lectures
Tutorialspoint

Export Data across multiple dumpfiles

1 Lectures
Tutorialspoint

Estimate dumpfile size

1 Lectures
Tutorialspoint

Spread dumpfiles across disks

1 Lectures
Tutorialspoint

Datapump Scenarios

7 Lectures
Tutorialspoint

Locking issues during export/import

1 Lectures
Tutorialspoint

Monitor progress for each object type

2 Lectures
Tutorialspoint

Load data through network

2 Lectures
Tutorialspoint

Master table analysis

4 Lectures
Tutorialspoint

Compression levels

1 Lectures
Tutorialspoint

Configure NFS mount

1 Lectures
Tutorialspoint

Datapump parameters in RAC

3 Lectures
Tutorialspoint

Consistent backup

1 Lectures
Tutorialspoint

Logfile exclude

1 Lectures
Tutorialspoint

Access methods

1 Lectures
Tutorialspoint

User definition backup

2 Lectures
Tutorialspoint

Objects definitions in a SQL file

4 Lectures
Tutorialspoint

Export Samples of data

1 Lectures
Tutorialspoint

Query filter using expdp

1 Lectures
Tutorialspoint

Data Obfuscation

1 Lectures
Tutorialspoint

Archivelog disable during import

1 Lectures
Tutorialspoint

Optimize datapump

3 Lectures
Tutorialspoint

Limit parallel worker at database level

2 Lectures
Tutorialspoint

Instructor Details

user profile image

Kishan m

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual 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

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515