Transport

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 …

ORA-600 [] and ORA-8103 errors can happen after TTS Import into 19c

This is not a new finding – and it is a very rare error. But you may only find it days, months or even years after a TTS migration has been completed. You may see a rare corruption issue, and it may sleep in your database. The error pattern would be: ORA-600 [<objdchk>] and ORA-8103 errors can happen after TTS Import into 19c when you query certain data sets. A customer of ours has encountered this a two years after an xTTS migration in an archival database. And since my team works with a lot of large migrations, I think

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

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 …

Virtual Classroom Seminar 18: XTTS to the Extreme – Video and Slides and more

Posted on March 4, 2024 by Mike.Dietrich Transportable Workshop 2

Thanks for tuning in on Feb 22, 2024 into our Virtual Classroom Seminar 18: XTTS to the Extreme – Video and Slides and more are now available. And thanks for being such a great audience with so many questions.

Photo by Venti Views on Unsplash

Video Recording

As usual, you can access the full recording here.

Please find the entire contents section below in the video’s description. You don’t need to watch the entire seminar, you can also access only the sections you are interested in, or skip sections which are not on your focus.

00:08 – Welcome to

Virtual Classroom Seminar 18: Cross Platform Migration to the Extreme

Posted on February 19, 2024 by Mike.Dietrich Transportable Workshop 0

This week on Thursday, February 22, 2024 at 16:00h CET we’d like to invite you to our next Virtual Classroom Seminar 18: Cross Platform Migration to the Extreme. Take the chance to learn about the newest developments in cross-platform transportable tablespace migrations – and there is a lot to talk about.

Virtual Classroom Seminar 18: Cross Platform Migration to the Extreme

Photo by Venti Views on Unsplash

What will be the topics?

We’ll not only discuss but also demonstrate the newest developments and improvements in cross-platform migrations, especially for large and active databases. Learn about the new M5 migration scripts, see them in action – and get an idea …

Your UPGRADE and MIGRATION program at OCW23

Posted on September 4, 2023 by Mike.Dietrich OOW 4

Are you coming to Oracle Cloud World 2023 and to Oracle DatabaseWorld at CloudWorld? Then you should read on since this may be your upgrade and migration program at OCW23. We are desperately looking forward to see and meet you in 2 weeks in Las Vegas. Don’t forget to add the talks you’d like to visit to your schedule as some of the rooms have limited capacity. And at least one of our labs is already sold out.

https://www.oracle.com/database/upgrades/#rc30p2

Who’s speaking and HOL’ing?

Speakers and your lab hosts will be:

Roy Swonger
Mike Dietrich
Daniel Overby Hansen
Rodrigo Jorge

Choose your desired time zone version (DST) upgrade

Posted on May 24, 2023 by Mike.Dietrich Time Zone - DST Transportable 18

This morning I received a very reasonable question from a customer who has a time zone mismatch between source and target database. And he wants to transport into a PDB on Exadata. Even though, this sounds trivial at first sight, unfortunately it isn’t. But a bug fix done recently for a German automotive customer is very handy here. So let me show you how you can Choose your desired time zone version (DST) upgrade.

Choose your desired time zone version (DST) upgrade

Photo by Vince Veras on Unsplash

Where does the problem start?

In this particular – and not unusual case – the customer wants to migrate …

Test Transportable Tablespaces without Read-Only Mode

Posted on October 2, 2020 by Mike.Dietrich Transportable 2

From time to time I deal with Transportable Tablespaces as an upgrade and migration approach. But TTS has one major flaw, especially when databases get really really big in the 3-digit-terabyte sizes or more: You will need to switch your tablespaces into read-only mode. But since Oracle Database 19c, you can Test Transportable Tablespaces without Read-Only Mode.

Test Transportable Tablespaces without Read-Only Mode

Photo by freestocks on Unsplash

Transport Constraints

Transportable Tablespaces (TTS) is a very common technique, especially when you need to migrate databases across Endianness. Since Oracle 10g, TTS works even from Big Endianness to Little Endianness platforms, and vice versa. Only if …

Transport

Take special care on Oracle Text when you migrate with TTS

What is TTS all about?

ORA-600 [] and ORA-8103 errors can happen after TTS Import into 19c

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

What is the

Virtual Classroom Seminar 18: XTTS to the Extreme – Video and Slides and more

Video Recording

Virtual Classroom Seminar 18: Cross Platform Migration to the Extreme

What will be the topics?

Your UPGRADE and MIGRATION program at OCW23

Who’s speaking and HOL’ing?

Choose your desired time zone version (DST) upgrade

Where does the problem start?

Test Transportable Tablespaces without Read-Only Mode

Transport Constraints

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts