Transportable

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 …

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

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

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

Virtual Classroom Seminar 12: Migrating Very Large Databases on Dec 9, 2021

Posted on December 8, 2021 by Mike.Dietrich Workshop 2

It looks to me that every possible event in 2021 happens in October/November/December 2021. No complaint from my side – but just in case you wonder about so little update activity on our blogs since weeks. We are just so busy in delivering virtual seminars. Which is good – but it requires lots of effort on our side as we want to deliver decent quality and real tech content. And now, since the year is almost at its end, it is time for our final Virtual Classroom Seminar 12: Migrating Very Large Databases on Dec 9, 2021 this year.

Virtual Classroom Seminar 12: Migrating Very Large Databases on Dec 9, 2021

Photo

PERL scripts for large migrations supported on all platforms (except Windows)

Posted on May 18, 2017 by Mike.Dietrich Transportable Uncategorized 5

This topic fits very well as I present about +100 TB migrations today at the “Harmony” User Group Conference in Finland.

Finland in May

The question whether the PERL scripts for RMAN incrementally rolled forward backups we deliver via MOS Note 1389592.1 (11G – Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup) will be supported for migrations to non-Exadata systems such as Oracle SuperCluster as well.

And yes, now we got an update into the note saying:

Although preferred destination system is Linux (either 64-bit Oracle Linux or a certified version of RedHat Linux), this procedure can be used …

Full Transportable Export/Import – Things to Know

Posted on July 4, 2016 by Mike.Dietrich TDE - Transparent Database Encryption Time Zone - DST Transportable 8

This blog post is an addition to:

Full Transportable Export/Import – Migrating an 11.2.0.4 database to Oracle Database 12c- into the Oracle Cloud

Seth Miller commented the pitfall of having a serious issue during the Data Pump run, Data Pump exiting and not finishing, and you’ll have to do the entire backup/restore/incremental-roll-foward thing again. Without any doubt, this is no fun at all.

So let me point out a few things to take into consideration – and some of them are not obvious I guess.

Do you need to backup/restore/incremental-roll-forward again?

When you let do Data Pump all the manual …

Transportable

Take special care on Oracle Text when you migrate with TTS

What is TTS all about?

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

Monitor progress of Oracle Data Pump impdp

Monitor Data Pump progress during impdp

What object types are left?

Virtual Classroom Seminar 12: Migrating Very Large Databases on Dec 9, 2021

PERL scripts for large migrations supported on all platforms (except Windows)

Full Transportable Export/Import – Things to Know

Do you need to backup/restore/incremental-roll-forward again?

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts