Datapump EXPDP/IMPDP Realtime Course For Oracle DBA'S

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Install and Configure Oracle linux Setup

Lecture 1: Install OEL 7.8 in virtualbox

Lecture 2: Virtual box configuration for OEL 7.8

Lecture 3: Configure network adapters

Lecture 4: Enable IP address in OEL server

Lecture 5: Configure putty

Lecture 6: Download Oracle 12c preinstall using yum

Chapter 3: Install Oracle database software

Lecture 1: Copy file from windows to linux vm

Lecture 2: Oracle database software installation

Chapter 4: Install Oracle database

Lecture 1: Install Oracle database 12cR1

Chapter 5: Scratching the basics

Lecture 1: Basic prechecks to perform

Lecture 2: Roles for datapump

Lecture 3: Mandatory parameters for datapump

Chapter 6: Clone vm for source database

Lecture 1: Clone vm for dpprod

Lecture 2: Configure ip address for dpprod

Lecture 3: Configure listener and tnsnames file for dpprod

Chapter 7: Rename database using NID utility

Lecture 1: Database rename from dptest to dpprod using NID

Lecture 2: Changing the init files to dpprod

Chapter 8: Monitor datapump job

Lecture 1: Create a sample table for monitoring

Lecture 2: Monitor datapump by different ways

Chapter 9: Diagnose datapump jobs

Lecture 1: Enable trace for master and worker process of datapump job

Chapter 10: Create a parameter file

Lecture 1: Creating parfile

Chapter 11: Halt,resume,terminate and influence parallel of datapump

Lecture 1: Working on datapump export/import command prompt

Chapter 12: Export data across multiple dumpfiles

Lecture 1: Export data across multiple dumpfiles

Chapter 13: Estimate the size of the dumpfile before export

Lecture 1: Estimate the object size with expdp

Chapter 14: Spread dumpfile across multiple disks

Lecture 1: Spread dumpfile across multiple disks

Chapter 15: Different scenarios of using datapump

Lecture 1: Different scenarios part 1 (export the data)

Lecture 2: Scenario 3 : Import table to same schema in different database server

Lecture 3: Scenario 4 (import table to different schema)

Lecture 4: Scenario 3,4 (import table to same-different schema with new name)

Lecture 5: INCLUDE and EXCLUDE parameter options

Lecture 6: Scenario 8(Export multiple tables except few)

Chapter 16: Export views in table structure

Lecture 1: Export views in the form of tables

Chapter 17: Issues encountered and how to troubleshooting them while using datapump

Lecture 1: ORA-00054 Locking issues during import

Chapter 18: Monitor progress for each object type

Lecture 1: Monitor datapump statistics after each object type completion

Lecture 2: Print timestamp for each step in datapump

Chapter 19: Load data over network

Lecture 1: Data transfer through network

Lecture 2: Monitor network traffic

Chapter 20: Analyze master table

Lecture 1: Import master table

Lecture 2: Find out datapump command history of job

Lecture 3: Peek the contents in master table for impdp job

Lecture 4: Check Parallel servers used from Master table

Chapter 21: Compress data using expdp

Lecture 1: Compression levels and their tradeoffs

Chapter 22: Configure NFS mount

Lecture 1: Configure and Enable NFS mount

Chapter 23: Distribute Workers across RAC nodes

Lecture 1: Distribute worker across all RAC instances in cluster

Lecture 2: Directory should be shared in RAC for CLUSTER

Lecture 3: Distribute the workers across specific RAC instances

Chapter 24: Scenario 13: Take consistent export backup

Lecture 1: Take a consistent table backup using expdp

Chapter 25: Exclude logfile

Lecture 1: Dont create logfile

Chapter 26: Different Access Methods

Lecture 1: Access methods to be used

Chapter 27: Schema definition clone

Lecture 1: User definition backup

Lecture 2: Import cloned user definitions

Chapter 28: Deposit of object definitions into SQL file

Lecture 1: Extract data from dumpfile and import to SQL file in SQL format

Lecture 2: Filter metadata while saving to SQL file

Lecture 3: Maintain a repository of mini production database

Lecture 4: Database sampling with reduced storage

Chapter 29: Data sampling

Lecture 1: Export a sample of data using EXPDP

Chapter 30: Data filtering methods

Lecture 1: Scenario 10: Query filter using EXPDP

Chapter 31: Data obfuscation

Lecture 1: Obfuscation of sensitive data

Chapter 32: Disable Archivelog generation while import

Lecture 1: Disable archivelogs during impdp

Chapter 33: Performance optimization of datapump

Lecture 1: Optimize EXPDP

Lecture 2: Optimize IMPDP

Lecture 3: Import indexes and constraints from sqlfile

Chapter 34: 19c and 21c New features

Lecture 1: Limit the parallel worker at database level

Lecture 2: Limit the parallel at pdb level