expdp

Take special care on Oracle Text when you migrate with TTS

Posted on October 5, 2026 by Mike.Dietrich Transportable 0

Transportable Tablespaces or Full Transportable Export/Import are the common techniques you typically use when you are going to migrate larger databases from one operating system to a different one. Usually, a Endianness-change is involved. And very often you will use our M5 scripts to benefit of incremental backups to reduce the downtime. In the past weeks I learned from two customers that you need to take special care on Oracle Text when you migrate with TTS. Hence, again I need to thank you for sharing your findings with me.

Take special care on Oracle Text when you migrate with TTS

What is TTS all about?

For those you are approaching …

How to deal with statistics when you migrate?

Have you done migration projects in the past, or do you have some upcoming projects, and you wonder how you should treat all sorts of statistics in your database? What is the better option? Keep and migrate the existing ones? Regather them right away? A partial-move approach? How to deal with statistics when you migrate? Then this is for you. Sign up to our next Virtual Classroom Seminar on Thursday, June 18 at 14:00h CEST: Statistics and Migrations – Well-Kept Secrets Revealed

How to deal with statistics when you migrate?

Photo by Mika Baumeister on Unsplash

What’s the topic?

Statistics and Migrations – Well-kept Secrets Revealed…

Monitor progress of Oracle Data Pump impdp

Posted on October 26, 2023 by Mike.Dietrich Data Pump 11

This blog post is a quick brain dump. I realized that I have so many “blog posts to write” that I need to dump the ideas or information much quicker. So, feel free to comment and correct. These queries may be useful when you run a larger import, and you would like to monitor progress of Oracle Data Pump impdp.

Monitor progress of Oracle Data Pump impdp

Photo by George Vidos on Unsplash

Monitor Data Pump progress during impdp

To monitor the progress of Data Pump during impdp you can use the following queries.

What object types are left?

select unique object_type_seqno, object_type
from system.sys_import_full_01
where

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

Posted on December 12, 2022 by Mike.Dietrich Data Pump Oracle Database 19c Patch Recommendation 46

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 17

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 …

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 …

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 …

Oracle Database 19.10.0 and Blockchain Tables and COMPATIBLE

Posted on February 18, 2021 by Mike.Dietrich Behavior Change Oracle Database 19c Parameters Patch Recommendation 4

Many of you recognized that we delivered a new feature with Oracle Database 19.10.0, the January 2021 Release Upgrade. So I’d like to put a few interesting things together from the upgrade and migration perspective regarding Oracle Database 19.10.0 and Blockchain Tables and COMPATIBLE.

Oracle Database 19.10.0 and Blockchain Tables and COMPATIBLE

Photo by Daniel von Appen on Unsplash

What are Blockchain Tables?

At first, I don’t want to repeat what other people have blogged and written about already. You may just go through the blog posts of Connor McDonald and Tim Hall and others to learn more about this cool feature.

Connor McDonald about “Blockchain

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.…

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

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

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

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 …

ORACLE_MAINTAINED attribute can be pretty helpful

Posted on March 21, 2018 by Mike.Dietrich General 11

You may have seen my two blog posts about Oracle supplied objects and Oracle supplied user schema and roles a few days ago, One person commented asking about what to do with these. And I agree: It looks a bit harsh to deal with two external files to query Oracle supplied stuff. But actually (as Patrick Hurley commented as well) there is a much easier way since Oracle Database 12c to deal with objects created and supplied by Oracle: the ORACLE_MAINTAINED attribute can be pretty helpful.

ORACLE_MAINTAINED attribute can be pretty helpful

In Oracle Database 12.1.0.1 we added a column …

What happens to PASSWORD_VERSIONS during an upgrade to Oracle 12.2?

Posted on April 25, 2017 by Mike.Dietrich Oracle Database 12.2.0.1 Security 27

I did blog a day ago about ORA-1017 connection issues in Oracle Database 12.2 once you would like to use the deprecated init.ora/spfile parameter SEC_CASE_SENSITIVE_LOGON=FALSE:

Having some fun with SEC_CASE_SENSITIVE_LOGON and ORA-1017

But how can this change actually happen?

Let’s check how the PASSWORD_VERSIONS is set in a fresh Oracle Database 12.1.0.2 database with the January 2017 Proactive Bundle Patch applied to it:

SQL> select username, password_versions from dba_users order by 1;

USERNAME		       PASSWORD_VERSIONS
------------------------------ -----------------
ANONYMOUS
APPQOSSYS		       10G 11G 12C
AUDSYS			       10G 11G 12C
DBSNMP			       10G 11G 12C
DIP			       10G 11G 12C
GSMADMIN_INTERNAL	       10G 11G 12C
GSMCATUSER		       10G

How to get the Master Table from a Data Pump expdp?

Posted on July 19, 2011 by Mike.Dietrich Data Pump 0

Pump Interesting question a customer had last week during the Upgrade Workshop in Munich. He’s getting export dump files from several customers and often not much information describing the contents. So how can ge find out what’s in there, which was the source characterset etc.

This seems to be a simple question but it did cost me a few searches and tests to come back with some (hopefully) useful information.

First attempt: $strings expdp.dmp > outexpdp.txt

I bet there are better ways to do this but in my case this will give me:

"APP"."SYS_EXPORT_SCHEMA_01"
x86_64/Linux 2.4.xx
WE8ISO8859P15
LBB EMB GHC JWD

expdp

Take special care on Oracle Text when you migrate with TTS

What is TTS all about?

Monitor progress of Oracle Data Pump impdp

Monitor Data Pump progress during impdp

What object types are left?

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

What is in the Data Pump Bundle Patch?

Migrating Flashback Data Archive (FDA) tables

What is Flashback Data Archive (FDA)?

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

When will it happen?

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

Upgrade-supported Releases

Oracle Database 19.10.0 and Blockchain Tables and COMPATIBLE

What are Blockchain Tables?

Does Data Pump import only serially into PDBs?

Very simple test setup

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

High Level Overview

Export with Data Pump and Long Identifiers

Export with Data Pump and Long Identifiers

ORACLE_MAINTAINED attribute can be pretty helpful

ORACLE_MAINTAINED attribute can be pretty helpful

What happens to PASSWORD_VERSIONS during an upgrade to Oracle 12.2?

But how can this change actually happen?

How to get the Master Table from a Data Pump expdp?

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts