Migration

AI World 2026: Upgrade, Migration and Patching Sessions

Now it is your task. Mark your sessions for AI World 2026. Currently, the session schedule has been published. But the rooms aren’t finalised yet. Why? Because we are counting favorite markers to be able to move sessions with high demand to larger rooms. Below, you find our list of AI World 2026: Upgrade, Migration and Patching Sessions. And it’s time to mark your preferences. We clearly look forward to meet you soon in person. It’s the best time of the year when we all get together and see our customers in person!

AI World 2026: Upgrade, Migration and Patching Sessions

Oracle AI World 2026:

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 …

AI World 2026: Pre-Event Masterclass: Upgrade, Migration and Patching

Posted on September 23, 2026 by Mike.Dietrich OCW OOW Workshop 2

AI World this year in Las Vegas is going to happen in about 4.5 weeks from now on. In case you’ll be there on Sunday (which makes perfect sense this year), you may want to consider signing up at AI World 2026: Pre-Event Masterclass: Upgrade, Migration and Patching. Yes, we are doing it again. A full day of specially curated content – with very little overlap with out talks and labs. You are having a full day from 9-5 with the guys who breath upgrades, migrations and patching everyday.

AI World 2026: Pre-Event Masterclass: Upgrade, Migration and Patching

Why should you consider it?

First of all, it is …

LAOUC 2026: Paraguay, Brazil and Uruguay

Posted on August 18, 2026 by Mike.Dietrich User Groups Workshop 0

In a week from now I should arrive in Asuncion, Paraguay, if all goes well. It it time for the Latin America Oracle User Group tour 2026 – and it has been started already going from north to south. I will participate in three stops at LAOUC 2026: Paraguay, Brazil and Uruguay. And I am looking forward to see you soon.

Paraguay

🇵🇾 August 26 | Paraguay | Oracle Users Group Paraguay (OUGPY)

Yeah, you beat us Germans at the world cup, and luckily, I did not watch it since I was traveling abroad. Congratulations 🙂 In reverse, I …

Transportable Tablespaces fails with ORA-01647 – TABLESPACE IS READ-ONLY

Posted on August 5, 2026 by Mike.Dietrich Transportable 2

This is a blog post I wanted to write a long time ago – and I missed it. Today, my best buddy Jony Safi shared an issue from a customer migration he had been pulled in the other day. I read the SR, and it dawned me that others may have seen this error as well. As a result, Transportable Tablespaces fails with ORA-01647 – TABLESPACE IS READ-ONLY – and there are two ways to solve this. Let me add ORA-6512 and ORA-1647 in case you search without the trailing zero.

Transportable Tablespaces fails with ORA-01647 - TABLESPACE IS READ-ONLY

Photo by Ben Harritt on Unsplash

What is the

How to deal with statistics when you migrate?

Posted on June 11, 2026 by Mike.Dietrich Oracle AI Database 26ai Oracle Database 19c SPA - SQL Performance Analyzer Statistics Workshop 0

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…

Upcoming in-person workshops in Düsseldorf, London, Vienna, Utrecht and Brussels

Posted on March 26, 2026 by Mike.Dietrich Workshop 0

I am ready to take off for some vacation soon. But I’d like to share with you a list of the upcoming workshops we are offering. All those events are in-person events – except the Virtual Classroom Seminar I will list below. Therefore, you need to show up at the day of the event. Zero marketing, no duplication of content either. See you soon in one of the upcoming in-person workshops in Düsseldorf, London, Vienna, Utrecht and Brussels.

Upcoming in-person workshops in Düsseldorf, London, Vienna, Utrecht and Brussels

Workshops and Events in April / May 2026

It is very important to say that we aren’t duplicating content. This …

Don’t use AI to build your AutoUpgrade config file, please!

Posted on February 13, 2026 by Mike.Dietrich AutoUpgrade Oracle AI Database 26ai Oracle Database 19c Upgrade / Migration 4

Let me do a quick Friday rant. Many of you can easily ignore this. But regardless of whether you are a colleague, a friend, a customer, a partner or just exploring AutoUpgrade because it is the coolest small tiny little tool Oracle has to offer, don’t use AI to build your AutoUpgrade config file, please!

Don't use AI to build your AutoUpgrade config file, please!

Photo by Enchanted Tools on Unsplash

AI models are great … somehow …

No worries, I use AI tools as well, especially when I need to create some complex PL/SQL scripts. There is nothing wrong with it – unless you stay in control. I …

Transportable Tablespaces with M5 scripts support now 26ai

Posted on February 4, 2026 by Mike.Dietrich Minimal Downtime Transportable 4

We have a lot of information in our seminars and blogs about Transportable Tablespace migrations. And since we have the M5 scripts for RMAN incrementally rolled forward backups and new RMAN functionality which avoids the spare storage, life has gotten so much easier. Now, some great news from the authors of the M5 scripts: Transportable Tablespaces with M5 scripts support now 26ai.

Transportable Tablespaces with M5 scripts support now 26ai

Photo by Mathew Antony on Unsplash

M5? Almost as fast as the car!

Some of you may still know the V4 PERL scripts. They had an evolution from V1 to V4 over the years and were our …

Oracle AI World 25: Upgrade to Oracle AI Database 26ai – let’s do it again

Posted on October 16, 2025 by Mike.Dietrich OOW Oracle AI Database 26ai 0

We’ll do it another time. This is your chance in case you missed our session on Tuesday:

Marco Polo 806, Level 1
Upgrade to Oracle AI Database 26ai: Best Practices and Customer Experience [LRN4241]

We collided with the delayed keynote of Larry Ellison, and obviously attending the keynote was way more important than our talk. Therefore, if you couldn’t show up but still want to learn about the replacement of Oracle Database 23ai with Oracle AI Database 26ai, then THIS is your final chance.

Oracle AI World 25: Upgrade to Oracle AI Database 26ai - let's do it again

We will show you the new release numbering schema, clarify whether you need to …

Oracle AI World 2025: Your guide to Upgrade, Migration and Patching Sessions

Posted on September 18, 2025 by Mike.Dietrich OOW 0

Oracle OpenWorld had been renamed to Oracle CloudWorld, and it got rebranded to Oracle AI World this year. And we PMs, Alex, Daniel, Rodrigo and myself look forward to see you there. It’s a perfect opportunity to touch base, discuss your migration challenges, your patching fun – and upgrades certainly, too. You not only can grab a sticker for your laptop lid but we’d love to hear about your experiences, wishes and pain points (if there are any) first hand.

Oracle AI World 2025: Your guide to Upgrade, Migration and Patching Sessions

And of course, we want you to come to our sessions. As usual, we’ll bring real stuff making …

Full Day Upgrade / Migration / Patching Workshop in Prague on September 17, 2025

Posted on September 2, 2025 by Mike.Dietrich Upgrade / Migration Workshop 0

Summer season is almost over. And in between Oracle AI World in Las Vegas in October and now, there is one chance to meet us for a Full Day Upgrade / Migration / Patching Workshop in Prague on September 17, 2025. There are still some seats open, so please find the details below.

Full Day Upgrade / Migration / Patching Workshop in Prague on September 17, 2025

Photo by Ryan Lum on Unsplash

When and why should you attend?

September 17, 2025 – 9:30h-16:30h.

This is a full package of marketing-free technical content – we share not only slides but also information from our projects, lots of customer experience, gotchas, tips and …

Recap AIOUG OCYatra 2025 – a trip through India

Posted on July 31, 2025 by Mike.Dietrich Autonomous Database - ADB AutoUpgrade Workshop 0

I just returned the other day from the most strenuous trips I do once a year: The AIOUG Oracle Community Yatra tour. 6 cities in 9 days. It’s a wild ride with flights and bus transfers in between, monsoon rain, heat and nasty mosquitos – but it is still one of the most exciting trips I do. So, let me recap AIOUG OCYatra 2025 – a trip through India. And explain what’s so special about it.

But at first, a huge THANK YOU to the organizers, especially to Sai and all the volunteers making this a …

AutoUpgrade migration to Oracle 23ai Exascale with Refreshable Clones

Posted on June 30, 2025 by Mike.Dietrich AutoUpgrade 0

Those of you who have been to our workshops in the past 3 years know that we promote one feature as the ultimate killer feature for moving to Oracle Database 19c and 23ai: Refreshable Clones. These work not only from PDB to PDB, but magically also with a non-CDB. And our teams works with a good number of customers using exactly this technique to Oracle 23ai. Now, we talked about it. And we blogged about it (see below). But there is a brand-new MOS note out there showcasing an AutoUpgrade migration to Oracle 23ai Exascale with Refreshable Clones.

AutoUpgrade migration to Oracle 23ai Exascale with Refreshable Clones

Photo by

Utrecht in Spring is beautiful – and we’ll be there on May 6

Posted on April 28, 2025 by Mike.Dietrich Workshop 0

No worries, I don’t start writing a travel blog. Or, maybe one day I will. But not for now. Daniel and I will be on the road again next week for a full day workshop in Utrecht on May 6 and in Brussels on May 7. Brussels is sold out already, the registration is closed. But in Utrecht we still have a few seats open due to the superb conference auditorium space in the Oracle office. Clearly, Utrecht in Spring is beautiful – and we’ll be there on May 6. And it is very close to Brussels in …

Upgrade 19c and 23ai Workshop in London on April 9, 2025

Posted on March 12, 2025 by Mike.Dietrich Workshop 5

London calling! Your chance to attend our first full-day Upgrade 19c and 23ai Workshop in London on April 9, 2025 in a decade. Yes, you read correctly. We’ve run such a workshop the last time in 2014. This was when you used an iPhone 6 at best case. Most importantly, this is an in-person only event. No streaming will be available.

Photo by Lachlan Gowen on Unsplash

How do you register?

Simple. No extra cost. Zero marketing. Just tech!! But be aware that you should free up your seat in case you can’t make it since we are really …

ADB Migration: Why does my SPA report has so many errors?

Posted on February 24, 2025 by Mike.Dietrich Autonomous Database - ADB Performance Tuning SPA - SQL Performance Analyzer 2

I’m dealing lately with several migration to Oracle Autonomous Database, mostly to ADB Serverless (called “shared” a while ago, in short: ADB-S). With one of the customers we run SQL Performance Analyzer reports with about 1500 statements. But one topic came up in this ADB Migration: Why does my SPA report has so many errors? Let’s see why that is …

ADB Migration: Why does my SPA report has so many errors?

Photo by Weichao Deng on Unsplash

A little bit of background on SPA

The SQL Performance Analyzer (SPA) is one of the two pieces of Real Application Testing. This is a feature in the database I keep using …

Refreshable clone with AutoUpgrade but keep your RAC configuration?

Posted on February 19, 2025 by Mike.Dietrich AutoUpgrade Single-/Multitenant 0

I had to shorten the headline a bit. It got very bulky saying at first: Use a Refreshable Clone with AutoUpgrade from non-CDB to PDB but keep your RAC configuration alive. Well, you see, that’s bulky. But it describes the case I would like to briefly show you. Helmut Pfau, a colleague of mine here in Germany asked this the other day, and it took us a bit to get the correct answer to him – I confess, simply because I didn’t know the right AutoUpgrade parameter.

Refreshable clone with AutoUpgrade but keep your RAC configuration?

Photo by Adrian Infernus on Unsplash

We love Refreshable Clones

You’ve …

OCW24: Upgrade, Migrations and Patching to Oracle Database 23ai

Posted on August 14, 2024 by Mike.Dietrich OCW OOW 0

Oracle Cloud World 2024 is near – in hot Las Vegas. Luckily, the hotel and conference areas are all air-conditioned. Good thing: You have another reason to enjoy the cold inside, and come to our talks and labs. Let me give you a quick overview, why we are so much looking forward to see you at OCW24: Upgrade, Migrations and Patching to Oracle Database 23ai sessions, labs and more.

Photo by Isaac Davis on Unsplash

Pre-Event Training: Multitenant Upgrade 23ai

You can book yourself a full-day pre-conference training on Monday, September 9. We’ll host a small group of …

Looking forward to YATRA 2024 Tour in India

Posted on July 8, 2024 by Mike.Dietrich Workshop 0

Time flies so quickly – and it is already July again. Next week I will fly out to India. And I am looking forward to YATRA 2024 Tour in India. It is always a vibrant experience with tons of energy in every room, with fully motivated people, awesome food and often some travel challenges, too.

What you need to do if you haven’t already? REGISTER NOW!!

Why should you register? Watch this video 🙂

Virtual Classroom Seminar 20: Migration to Oracle Multitenant 23ai – Part 2

Posted on June 24, 2024 by Mike.Dietrich Workshop 0

Needed a long title here. And if you haven’t registered yet, please do so now. Thursday, June 27, 2024, we are going to deliver our (potentially last for this year) Virtual Classroom Seminar 20: Migration to Oracle Multitenant 23ai – Part 2. If you missed part 1, no worries, you can watch it on-demand anytime.

Virtual Classroom Seminar 20: Migration to Oracle Multitenant 23ai - Part 2

Photo by Benjamin Voros on Unsplash

Again, we have an exciting deep-dive tech agenda with lots of bits and pieces, and thinks you may not know yet. Hence, regardless if you are already in the Multitenant architecture, or whether you plan to migrate …

Virtual Classroom Seminar #19 “Move to Oracle 23ai” is available – and #20 is coming soon

Posted on May 23, 2024 by Mike.Dietrich Workshop 0

Thanks to the over 350 people who attended our Virtual Classroom Seminar #19 – Move to Oracle Database 23ai: Everything you need to know about Multitenant PART 1 on May 16, 2024. And thanks as well for asking so many questions during the seminar. In case you couldn’t attend, or you’ve had to leave earlier, we are sharing the recording with you, and of course the slides as well.

Virtual Classroom Seminar #19 - Move to Oracle Database 23ai - Multitenant Part 1

What were the topics in VC#19?

In VC#19 we talked about the Oracle Multitenant architecture, how to design a new deployment, how the dictionary is laid out. In addition, you will …

A new version 24.1.0 of CPAT is available

Posted on April 9, 2024 by Mike.Dietrich CPAT 0

No worries, this blog won’t become a “new version” announcement blog. But after two weeks of relaxing Easter holidays I just start cleaning up my inbox and flushing out blog posts as soon as time allows. One thing I need to share with you is that a new version 24.1.0 of CPAT is available for download. CPAT? You may not have read about CPAT on my blog yet. But this will change in the future since the CPAT development is now part of our small team as well. And we get happily tied into more and more Autonomous Database (ADB) …

Oracle Cloud World 2024 in London

Posted on March 7, 2024 by Mike.Dietrich OCW OOW Workshop 0

Next week it’s Oracle Cloud World 2024 in London. And I hope to see you there. It is a perfect spot to get the latest tech updates but also to meet and synch and discuss.