Formação DBA Oracle Jr: DATAPUMP (expdp e impdp) na pratica

Explore the power of Oracle Data Pump with expdp and impdp! This course dives into the core features of these essential tools for database export and import.

Course Overview:

• Understanding Data Pump: Learn what Data Pump (using expdp and impdp) is and how it works. Discover the role of directory objects in Data Pump operations.
• Granular Data Export with expdp: Gain control over your data extraction. expdp allows for highly granular exports – unlike physical backups with RMAN – enabling you to selectively export data and metadata.
  • Key expdp Features:
    • expdp help: Quickly access command-line options.
    • Estimating Backup Size: Plan your exports effectively.
    • Exporting the Entire Database
    • Exporting Specific Tablespaces
    • Exporting Specific Schemas
    • Exporting Individual Tables
    • Using Flashback for Point-in-Time Recovery during export.
    • Exporting Data Only or Data & Metadata
    • Other Export Options
• Efficient Data Import with impdp: Seamlessly restore your database using impdp. Enjoy the same level of granularity as expdp for targeted imports.
  • Key impdp Features:
    • Importing the Entire Database
    • Importing Specific Tablespaces
    • Importing Specific Schemas
    • Importing Specific Tables
    • Table Remapping: Modify table names during import.
    • Table Renaming: Change table names during import.
    • Combined Remapping and Renaming
    • Importing Data Only or Data & Metadata
    • Other Import Options
• Extracting Metadata from Logical Backups: You don't always need to import to access metadata. Directly extract DDL (Data Definition Language) for tables and package code from exported files.
• Parameter Files for Streamlined Operations: Simplify your export and import processes by using parameter files (.par). Define all necessary clauses in a single file and pass it as an argument to expdp or impdp.
• Automation with Scripts: Automate your Data Pump workflows by creating scripts to execute exports and imports, focusing on validation for successful completion.

Prerequisites: Familiarity with character sets and tablespaces is beneficial. Understanding the basics of impdp help is also helpful.