Vice President, Database Upgrade, Patching, Migration & Utilities
Oracle Data Pump is one of the most widely used DBA-oriented features of Oracle Database, combining powerful flexibility with high speed movement of data and metadata into and between Oracle databases. Even if you already use Data Pump, have you ever wondered how it works internally, or why it behaves the way it does? If so, then this deep dive into Data Pump internals is for you! We will delve into the inner workings of this widely used utility to look at topics such as: – the different types of parallelism: what are they, when are they used, what are the pros and cons of each? – object filtering with EXCLUDE/INCLUDE: what is possible, what is not? – dumpfile file versus network mode: what's the difference, and why? – what is in the Data Pump Control table, and how is it used? Join Oracle Data Pump product management for a deep dive into these topics and perhaps more. You'll have a better understanding of this important tool for managing your databases.
Oracle Data Pump is widely used by DBAs to move tables, schemas, and even entire databases from one Oracle Database to Another. But, even if you are familiar with Data Pump, we will bet that there are some features that you might not be be using to their fullest potential. This session will cover some of the lesser known, "unsung" features of data pump that will help you unlock the power of this versatile utility. Some of the features we will discuss and demonstrate are – the TRACE parameter and its use in debugging issues – the interactive command line interface – the DBMS_DATAPUMP API – important and helpful patches for Data Pump on Oracle Database 19c Whether you are a casual user or a power user of Data Pump, you're sure to learn something that will come in handy in your export or import scenarios.