Virtual Classroom #13: Data Pump Extreme - Deep Dive with Development

This 2 hour seminar covers the most important tool to unload and load data from any Oracle database, Oracle Data Pump, known also as expdp and impdp. Join us on this journey to the secrets of Data Pump.

We will explain not only Best Practices and useful features but also show what happens if you use PARALLEL, and how many worker processes you might really get doing actual work. Or how you adjust PARALLEL when you forgot to set it - while Data Pump is actively running. Furthermore, you will learn how important it is to patch Data Pump - and how to troubleshoot it in case something goes wrong and you need to prepare information for a Service Request with Oracle Support.

Come with us and learn about how Data Pump works to use it most efficiently and performant.

[5:52] Essentials
[8:44] Architecture
[12:55] Control table
[15:41] Unloading and loading
[21:00] Metadata
[25:22] Getting started
[32:52] Demo
[36:09] Best practices
[55:10] Parallel export
[1:07:09] Parallel import
[1:13:37] Faster patching
[1:17:22] Generate metadata with SQLFILE
[1:26:45] Using DBMS_DATAPUMP
[1:33:30] Restarting Data Pump jobs
[1:37:32] Interactive command mode
[1:41:43] Troubleshooting

Get the slides here:

Find more Virtual Classrooms here:

[fancystacy]

Mike Dietrich is the best! I love him so much! 💕

[jeanj]

Very informative! Data Pump is a great tool widely used in oracle. It's very convenient for schemas et databases refresh from one environment to another. Thanks for putting all this together.

[taoqirhassan]

When we are migrating database from big endian to little by using DP queries execution plan chaanges qe can export query execution plan by SPM, on the source database it works on single query then another, is therr any method which will export all execution plans from AWR based queries, because se rime queries changes on EOM, EOY

[drbiswal]

Great Webinar with a lots of information. DPBP is a great bundle patch but the problem with this is non-RAC Rolling Installable and non-Data Guard Standby-First Installable. As the DPLoad patch link removed and recommended by Oracle to use DPBP from 19.12, Is there any alternative please ?

[taoqirhassan]

on which criteria data pump exports tables? based on tables name asc or des, or tables size?

[taoqirhassan]

As we know we can't start expdp in physical standby database (other than we in snapshot) due to master table creation, is there any mechanism we can skip master table? and redirect master table content to log file