Pump Your Data Pump Skills

Data Pump 1 Minute

Oracle Data Pump is a powerful tool for moving data between databases, but many users only scratch the surface of what it can do. That’s why we created a hands-on lab that will take you beyond the basics and into the details.

Get started with Supercharge data movement with Data Pump.

Learn Oracle Database on Oracle LiveLabs

What Can I Learn

If you invest two hours, this is some of what you get in return:

  • Apply best practices
  • Deal with LOBs effectively
  • Speed up imports using NOVALIDATE constraints
  • Use checksums and encryption to validate your dump files
  • Monitor and trace a job
  • Start a job using the PL/SQL interface

If you’re looking for more details, check out the lab instructions.

Oracle LiveLabs

The lab runs in Oracle LiveLabs.

  • Completely free
  • Nothing to install
  • Runs in a browser

You can check our other labs or flip through the huge catalog of labs on Oracle Database.

Get Started

Start your lab today.

If you want more on Data Pump, check our webinars Data Pump Extreme – Deep Dive with Development and Data Pump Best Practices and Real World Scenarios.

Never Stop Learning

Published

5 thoughts on “Pump Your Data Pump Skills”

  1. Loved the lab, learned a lot.

    I did encounter an issue with the session limits when trying to do a parallel export, 2 sessions is not enough. Also had to switch to multiple fixes to avoid hitting the ORA-39095: Dump file space has been exhausted limit. However using these 2 items parallel and multiple files, I took a 9 minute export to a 2 minute export on our system.

    Like

    Reply

    1. Hi,

      Thanks for the feedback. I’m glad that you found it useful.

      In which of the labs did you encounter problems? If you could send me some more details on the problem – I’ll fix them right away.

      You can reach me on daniel.overby.hansen (a) oracle.com.

      Thanks,
      Daniel

      Like

      Reply

      1. Sorry Dan, If I did not clarify the issue I encountered where on our servers. I encountered no issues in the lab environment. Maybe a little bit of user errors, but nothing in the lab itself.

        Keep up the great work.

        Like

        Reply

      2. Sorry Dan, If I did not clarify the issue I encountered where on our servers. I encountered no issues in the lab environment. Maybe a little bit of user errors, but nothing in the lab itself.

        Keep up the great work.

        Like

        Reply

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.