Oracle Data Pump (Impdp / Expdp )

Focused View

Vivek Kumar Gupta

1:33:23

10 View

1. Introduction

1. Introduction.mp4

02:48

2. Preparing Course Practice Enviornment

1. Practice - Preparing Course Practice Environment (part 1 of 2).mp4

21:48

2. Practice - Preparing Course Practice Environment (part 2 of 2).mp4

17:22

3. Oracle Data Pump

1. Oracle Data Pump Architecture.mp4

09:41

4. Parameter of Data Pump

1. DIRECTORY and DUMPFILE.mp4

01:58

2. LOGFILE and CONTENT.mp4

02:23

3. ESTIMATE and ESTIMATE ONLY.mp4

01:50

4. FLASHBACK SCN and FLASHBACK TIME.mp4

02:22

5. NETWORK LINK , PARALLEL and PARFILE.mp4

03:01

6. SCHEMAS ,TABLES and TABLESPACES.mp4

01:40

7. ATTACH , KILL JOB , START JOB ,STATUS , STOP JOB.mp4

01:33

5. Difference between traditional (impexp )and Data Pump

1. Diff bw traditional and Datapump.mp4

06:25

6. Expdp Impdp

1. Expdp Impdp (part 1 fo 2).mp4

09:33

2. Expdp Impdp (part 1 fo 2).mp4

07:12

7. Schema Refresh

1. Schema Refresh.mp4

03:47

8. Interview Question

1. Interview Question.html

Description

Oracle Data Pump (Impdp / Expdp )

What You'll Learn?

install configuration Oracle 19c Database
understand Data pump Vs Imp/Dmp
Parameter of Data Pump
Schema Refresh using Data Pump

Who is this for?

Oracle Database administrator

System Integrator

Data Warehouse Analyst

Data Warehouse Developer

What You Need to Know?

Familier with Oracle Database

Familiar with Linux basics

More details

Description
This comprehensive course on Oracle Data Pump provides an in-depth understanding of the Import (Impdp) and Export (Expdp) utilities, essential tools for managing data and metadata movement in Oracle databases. Participants will gain hands-on experience with practical examples and real-world scenarios to master the intricacies of these powerful data manipulation tools.

Prerequisites:
Basic understanding of Oracle Database concepts
Familiarity with SQL and PL/SQL
Oracle Database installed (preferably Oracle Database 11g or later)
Introduction to Data Pump:
Overview of Oracle Data Pump architecture
Key differences between the original Export/Import utilities and Data Pump
Basic Data Pump Commands:
Syntax and usage of expdp and impdp commands
Connecting to databases and specifying target schemas
Exporting Data:
Exporting entire databases, schemas, or specific tables
Filtering data during export using various parameters
Parallelism and performance considerations
Importing Data:
Importing data from dump files
Handling tablespace and schema remapping
Strategies for handling errors and exceptions during import
Advanced Data Pump Features:
Data compression and encryption during export and import
Fine-grained control over object creation and manipulation
Using Data Pump transformations and SQL queries during import
Managing Data Pump Jobs:
Monitoring and managing Data Pump jobs
Resuming and restarting failed jobs
Controlling job behavior and resource usage
Best Practices and Optimization:
Optimizing performance with parallelism and parallel processing
Best practices for efficient data movement and maintenance
Who this course is for:
Oracle Database administrator
System Integrator
Data Warehouse Analyst
Data Warehouse Developer

User Reviews

Rating

average 0

Total votes0

Focused display

Oracle Database

Vivek Kumar Gupta

Instructor's Courses

Vivek Kumar Gupta is a Senior Associate with 6 years of experience in the computer industry, specializing in Oracle database administration technologies for complex and high-availability environments. With his expertise in designing and maintaining database solutions, he has successfully catered to a wide range of complex business needs using various technologies such as Oracle RAC, ASM, Data Guard, GoldenGate, WebLogic, Database Appliance, and Enterprise Manager. Vivek has had the opportunity to work MNC firms Like HCL Technology ,Kyndryl which has helped him gain a global perspective. In his leisure time, he enjoys playing soccer, listening to soft music, and spending quality time with his adorable pet cat.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.