Oracle Data Pump Internals
Event: Connect 2021, Connect 2021-Cloud
Stream: Architecture, Cloud Database & Technology
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.