Data Pump

Apply the Data Pump Bundle Patch – non-rolling but online?

Yesterday I have blogged about an issue with the highly recommended Data Pump Bundle Patches. And today I would like to shed some light on how to Apply the Data Pump Bundle Patch – non-rolling but online?

Apply the Data Pump Bundle Patch - non-rolling but online?

Photo by eberhard 🖐 grossgasteiger on Unsplash

Download the Data Pump Bundle Patch

You can download the correct Data Pump Bundle Patch from MOS Note: 2819284.1 – Data Pump Recommended Proactive Patches For 19.10 and Above. It’s just a few MB, and it is a generic patch with a separate download for the Windows platform. So far so good.

…

Data Pump Bundle Patches: You may need to download and apply again

The Data Pump Bundle Patches get released on top of every RU since over a year now. But a real issue with missing files got detected recently. So in case you had applied Data Pump Bundle Patches: You may need to download and apply again.

Data Pump Bundle Patches: You may need to download and apply again

Photo by Khamkéo Vilaysing on Unsplash

What is in the Data Pump Bundle Patch?

The Data Pump Bundle Patch is a convenient and very useful vehicle to apply Data Pump patches which are usually not included in a Release Update (RU). While RUs are per definitionem RAC-rolling and Standby-First, the Data Pump Bundle …

Migrating Flashback Data Archive (FDA) tables

Posted on April 8, 2022 by Mike.Dietrich Export - Import 9

This morning I received an email question from a customer asking whether there is support for the Migrating Flashback Data Archive (FDA) tables in Oracle 19c. And since this is not the first time I received this question, I thought it may be good to have a blog post about it.

Photo by Anita Jankovic on Unsplash

What is Flashback Data Archive (FDA)?

Well, google it. Actually I was looking for a link in our documentation but to my surprise I found the usual suspects such as Tim Hall’s excellent oracle-base page – but not much in our own doc …

We are hiring … Developers and a Product Manager

Posted on March 29, 2022 by Mike.Dietrich Job Offering 0

Our team is growing – not only the Upgrade team but also the Data Pump team. And we have a challenging new project where we search developers for. So yes, We are hiring … Developers and a Product Manager.

We are hiring ... Developers and a Product Manager

Photo by Ashley de Lotz on Unsplash

Software Developer – Cloud Migration Analyzer

At first, we are looking mostly for skilled developers. We have a new challenging and interesting project which our VP, Roy Swonger, owns. And there we look at first for developers with either very good APEX skills but also database knowledge or people who are good in programming …

Virtual Classroom Seminar 13 Data Pump – Slides, Video and QA

Posted on March 8, 2022 by Mike.Dietrich Video / Viewlet Workshop 4

Thanks a lot to everybody who tuned in last week to our Virtual Classroom Seminar #13: Data Pump Extreme – Deep Dive with Development. We’ve had almost 600 attendees, and many of you stayed for the two full hours. And let me tell you that this is just awesome since there are enough people who think that a session has to be just 30 minutes or less. And of course, no it is time to share: Virtual Classroom Seminar 13 Data Pump – Slides, Video and QA.

Virtual Classroom Seminar 13 Data Pump - Slides, Video and QA

Photo by Pim Chu on Unsplash

The slides

As usual, you can …

Virtual Classroom Seminar 13: Data Pump Extreme – Deep Dive with Development

Posted on March 1, 2022 by Mike.Dietrich Workshop 10

We worked very hard in the past weeks to compile our newest Virtual Classroom Seminar 13: Data Pump Extreme – Deep Dive with Development for you. Now it’s time to sign up for Thursday, March 3, 2022.

Virtual Classroom Seminar 13: Data Pump Extreme - Deep Dive with Development

When will it happen?

Our 13th Virtual Classroom Seminar will happen this Thursday, March 3, 2022 at a hopefully convenient time for you:

14:00h CET – 13:00 BST – 10 a.m. EST – 7 a.m. PST – 20:00h IST

As usual, we will be available to all your Data Pump questions throughout the entire seminar. Just use the QA option of the zoom …

Virtual Classroom Seminar: Fallback Is Your Insurance – on Nov 11, 2021

Posted on November 10, 2021 by Mike.Dietrich Workshop 4

No worries, I haven’t become lazy recently. But the past weeks were more busy than anything I have experienced so far. And I had a full week off and enjoyed the silence and absence from blogs and cell phones and email in the mountains. But now I’m back – and surprise, surprise – this week on Thursday we’ll have our 11th Virtual Classroom Seminar: Fallback Is Your Insurance – on Nov 11, 2021.

Fallback Seminar

When will it happen?

Thursday, Nov 11, 2021 – 10:00h CET

What are we going to talk about?

Fallback and Rollback. How to secure your job. …

Which releases allow you to upgrade to Oracle Database 21c?

Posted on August 31, 2021 by Mike.Dietrich Oracle Database 21c 2

As I wrote before, the release you should upgrade to is clearly Oracle Database 19c. Unless you need to use one of the new features in Oracle 21c. But as you have seen in the past, some of them get backported to 19c as well. Still, in case you can’t resists or you love upgrades as much as we do, the question may be: Which releases allow you to upgrade to Oracle Database 21c?

Upgrade-supported Releases

The Database Upgrade Guide for Oracle 21c is your best friend here. Right at the beginning in the first chapter you will find this …

We are hiring: Software Development Senior Director “Database Utilities”

Posted on August 5, 2021 by Mike.Dietrich General 0

This is the first time that I send out such a blog post. But since many of you read this blog, and a high number of people follow me on LinkendIn, maybe you’ll be interested as We are hiring: Software Development Senior Director “Database Utilities”. And it could be you!

We are hiring: Software Development Senior Director "Database Utilities"

Photo by Alessandro Erbetta on Unsplash

I can tell you by heart that you’d join one of the best teams in Oracle.

So please read the job description here – and if your profile matches plus you are looking for a new challenge, you should apply right away. You …

aioug Webinar Series July 2021: Database Upgrade and Migrations

Posted on June 28, 2021 by Mike.Dietrich Workshop 0

Many people on the northern hemisphere will escape during July into the summer holidays. But we won’t. Instead, thanks to Sai Penumuru, we will give seven webinars for the aioug. And we are looking forward to talk to you soon at the aioug Webinar Series July 2021: Database Upgrade and Migrations.

aioug Webinar Series July 2021: Database Upgrade and Migrations

When will it happen?

This morning I looked into my calendar. And I realized: Wow, July 2021 is just a few days away. Roy will start with the first session on Friday, July 2. And then myself, Rodrigo, Daniel, Fred and Bill will …

Data Pump Super Patch for Oracle 19.10 and newer

Posted on April 15, 2021 by Mike.Dietrich Data Pump Patch Recommendation 64

Just a few days we released a Data Pump Super Patch for Oracle 19.10 and newer. “Newer” refers to the fact that once 19.11.0 will be available, this merge patch I’m writing about will be available as well right away (sorry, got delayed a bit). And if you work with Data Pump, you may want to consider this performance patch collection.

Photo by paolo candelo on Unsplash

Why do you need this patch?

Many customer will know the issue that adding changes with datapatch may take a long time as soon as dpload.sql is involved. And this …

Sign up for the Upgrade 19c Virtual Classroom Seminars for the US, Canada and LAD

Posted on January 21, 2021 by Mike.Dietrich Workshop 7

It took a while. And many of you asked whether we will run our Virtual Classroom Seminars we ran successfully for Australia and New Zealand in April and from June to now in EMEA for the US, Canada and South and Latin America time zones as well. And we do. It’s time to Sign up for the Upgrade 19c Virtual Classroom Seminars for the US, Canada and LAD.

Photo by Philippe Bout on Unsplash

Everything you need to know about Upgrade, Migration and Consolidation

When we ran these events especially for EMEA, a lot of colleagues asked us whether …

Does Data Pump import only serially into PDBs?

Posted on October 15, 2020 by Mike.Dietrich Data Pump 7

Daniel and I did Web Seminars this week. One of them was about the different migration strategies. We did talk a lot about Data Pump. One attendee mentioned that Data Pump Import does not work parallel into PDBs in Oracle 12.2.0.1 and Oracle 18c. We were skeptical, and today I tried out to check: Does Data Pump import only serially into PDBs?

Does Data Pump import only serially into PDBs?

Photo by Nikola Johnny Mirkovic on Unsplash

Very simple test setup

For this test, I take a schema export from an 11.2.0.4 database in our Hands-On Lab, the TPCC user HammerORA uses in the UPGR database.…

Upgrade to Oracle 19c – Virtual Classroom Series – Parts 5 and 6

Posted on October 1, 2020 by Mike.Dietrich Workshop 2

October will be a very busy month. Daniel and I are putting the slides together at the moment for the upcoming Upgrade to Oracle 19c – Virtual Classroom Series – Parts 5 and 6. We will speak about “Database Migration Techniques” and about “Move to the Cloud – For Techies Only“. No worries if you missed Parts 1-4 as you can watch all of them online on-demand. Find all links below.

Upgrade to Oracle 19c – Virtual Classroom Series - Parts 5 and 6

Photo by Austin Distel on Unsplash

Register for the Virtual Classroom Part 5 and Part 6 events

Find the overview for both events here …

Database Migration from non-CDB to PDB – Migration with Data Pump

Posted on August 14, 2019 by Mike.Dietrich Data Pump Single-/Multitenant 10

You may have realized that there are a few techniques missing describing how to do a Database Migration from non-CDB to PDB – Migration with Data Pump is one of them. I will explain the most simple approach of going to Single- or Multitenant. It isn’t the coolest – and it isn’t very fast as soon as your database has a significant size. But it is not complex. And it allows you to move even from very old versions directly into an Oracle 19c PDB – regardless of patch levels or source and destination platform.

Database Migration from non-CDB to PDB – Migration with Data Pump

High Level Overview

Endianness change

Behavior Change in Oracle 18c/19c: No symbolic links for Data Pump directories

Posted on July 15, 2019 by Mike.Dietrich Behavior Change 8

Most of you may have recognized the desupport of UTL_FILE_DIR with Oracle Database 18c. Reason is mostly that UTL_FILE_DIR opens a lot of possibilities to do insecure things. But this has another effect which may not be obvious to you. There’s a behavior change in Oracle 18c/19c: No symbolic links for Data Pump directories. Read further to learn more about it.

UTL_FILE_DIR Desupport

In Oracle Database 18c we announced the desupport of UTL_FILE_DIR initialization parameter. But as you can read as well in the Database Upgrade Guide, there’s this remark:

UTL_FILE Package Symbolic Link in Directory Paths Not Supported

Data Pump: The Time Zone Pitfalls

Posted on May 14, 2019 by Mike.Dietrich Flaws and Pitfalls 13

Photo by Luis Cortes on Unsplash

Last week a very experienced colleague called me. He had issues with an export dump taken from an Oracle 20c database importing into 19c. It failed. So this blog post is about Data Pump: The Time Zone Pitfalls.

The Case

Usually you will see this issue only when you try to export from a higher version, and then attempt to import into a lower one. But the same thing can happen when you patched your databases partially with a newer time zone patch regardless of the version.

My colleague saw this error:

impdp system/welcome1@//localhost:1521/MYDB

OOW 2018: How to Migrate to Oracle Autonomous Database Cloud

Posted on October 17, 2018 by Mike.Dietrich OOW 0

OOW 2018: How to Migrate to Oracle Autonomous Database Cloud

And last but not least our forth talk at OOW 2018: How to Migrate to Oracle Autonomous Database Cloud on Tuesday, Oct 23 at a fairly late slot at 5:45 p.m. (or 17:45h) as well in Moscone West 3004.

What is this talk all about?

It’s about the Oracle Autonomous Database cloud. But not so much about the Cloud offering itself. There are other talks covering this topic. We are the upgrade and migration guys. Hence, in this talk my boss, Roy Swonger and my PM mate Bill Beauregard will demonstrate you in a live demo how to migrate …

Data Pump 12.1.0.2 – Wrong Dump File Version – ORA-39142

Posted on July 16, 2018 by Mike.Dietrich Data Pump Flaws and Pitfalls Patch Recommendation 2

Data Pump 12.1.0.2 - Wrong Dump File Version - ORA-39142 Again I’ll have to thank my colleague Roland Gräff from the German ACS Support team in Stuttgart for bringing this into our radar. Roland alerted me a week ago about an issue with exports in Oracle 12.1.0.2 only when you are on a certain patch level. I summarize the issue here under Data Pump 12.1.0.2 – Wrong Dump File Version – ORA-39142.

In the below blog post you will learn about the actual issue, where it happens and when, and of course how to workaround it.

When does it happen?

The issue I will describe below happens only with …

Export with Data Pump and Long Identifiers

Posted on July 9, 2018 by Mike.Dietrich Data Pump 0

I blogged a few days ago about Long Identifiers in Oracle Database 12.2 and accessing the objects via database links from lower database version. As this raised a few questions, I realized there may be a bit more clarification necessary. One question was about what happens during export with Data Pump and Long Identifiers. That’s a pretty good question.

Export with Data Pump and Long Identifiers

I’d like to demonstrate the effect with a short example. I’m doing all my tests in a fresh PDB inside an Oracle 18.1.0 CDB from out Hands-On Lab. But you can repeat …

Upgrade and Migration Office Hours on March 21, 2018

Posted on March 16, 2018 by Mike.Dietrich Office Hours 0

The first Office Hours Session was just a month ago. It was a very good experience and based on the feedback we received from customers it was very helpful. You don’t believe it? Then you may watch the recording. But now it’s time for our second Upgrade and Migration Office Hours on March 21, 2018.

What are “Office Hours”?

This is a new interactive format we’d like to try out. Several groups in Oracle schedule Office Hours sessions. Roy and I held our first Office Hours session on February 21, 2018 for a full hour trying to answer …

Data Pump’s amazingly useful METRICS=Y and LOGTIME=ALL parameters

Posted on September 27, 2016 by Roy.Swonger Data Pump 7

Now that I am back from OpenWorld, I will hijack the Upgrade blog while Mike is traveling. 🙂

Thank you to everybody who came to our presentations or stopped at the demo booth to chat last week. We had a great many conversations, and we always learn from talking to customers! One of the common questions about Data Pump came in the form, “I have a data pump job that used to run in X minutes, but now takes <multiple of X> minutes. Can you tell me what might be happening?“

Of course with that much information we …

Data Pump – Exclude Stats differently for TTS and FTEX

Posted on April 20, 2016 by Mike.Dietrich Data Pump Transportable 15

Nice little best practice for statistics and Data Pump when doing either Transportable Tablespaces or Full Transportable Export-Import (credits to Roy and Dean Gagne).

Transport Statistics via a Staging Table

First of all we always recommend to exclude statistics when doing a Data Pump export as the import of such stats takes way longer than transporting them via a stats table. If you are unfamiliar with transporting stats between databases please see the Oracle Performance Tuning Guide with a nice tutorial:

Importing and Exporting Optimizer Statistics

The basic steps to transport statistics from one database to another fast and

Some Data Pump issues: DBMS_DATAPUMP Import via NETWORK_LINK fails + STATUS parameter giving bad performance

Posted on June 30, 2015 by Mike.Dietrich Data Pump 8

One of my dear Oracle ACS colleagues (Danke Thomas!) highlighted this issue to me as one of his lead customers hit this pitfall a week ago. .

DBMS_DATAPUMP Import Over NETWORK_LINK fails with ORA-39126 / ORA-31600

Symptoms are:

KUPW$WORKER.CONFIGURE_METADATA_UNLOAD [ESTIMATE_PHASE]
ORA-31600: invalid input value IN ('VIEWS_AS_TABLES/TABLE_DATA') for parameter VALUE in function SET_FILTER

This can be cured with the patch for bug19501000 – but this patch can conflict with:Bug 18793246 EXPDP slow showing base object lookup during datapump export causes full table scan per object and therefore may require a merge patch – patch 21253883 is the one to go …

Parallel Index Creation with Data Pump Import

Posted on April 10, 2015 by Roy.Swonger Data Pump Patch Recommendation 34

Here is a new capability that might be interesting to anybody who is performing a migration using Data Pump. Previously, Data Pump would create indexes one at a time, specifying the PARALLEL keyword for the CREATE INDEX statement to invoke parallel query for index creation. We used to recommend a workaround to create indexes in parallel, which involved a three-step process of importing without indexes, then creating a SQLFILE of the CREATE INDEX statements, and breaking that file into multiple windows.

Through extensive performance testing we found that it is faster to create multiple indexes in parallel (using a parallel …

Data Pump

Download the Data Pump Bundle Patch

What is in the Data Pump Bundle Patch?

What is Flashback Data Archive (FDA)?

Software Developer – Cloud Migration Analyzer

The slides

When will it happen?

When will it happen?

What are we going to talk about?

Upgrade-supported Releases

When will it happen?

Why do you need this patch?

Everything you need to know about Upgrade, Migration and Consolidation

Very simple test setup

Register for the Virtual Classroom Part 5 and Part 6 events

High Level Overview

UTL_FILE_DIR Desupport

The Case

What is this talk all about?

When does it happen?

Export with Data Pump and Long Identifiers

What are “Office Hours”?

Transport Statistics via a Staging Table

DBMS_DATAPUMP Import Over NETWORK_LINK fails with ORA-39126 / ORA-31600

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Follow me on Twitter

Recent Posts