Import

Monitor progress of Oracle Data Pump impdp

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 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 
Continue reading...

Migrating Flashback Data Archive (FDA) tables

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.

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 …

Continue reading...

APEX is in CDB$ROOT again – Journey to the Cloud VII

Well … it’s been a while … but I would like to continue my journey to the cloud …

What happened so far on my Journey to the Cloud?

DBaaS Oracle Cloud

Continue reading...

Full Transportable Export/Import White Paper

One of the really cool and helpful features in Oracle Database 12c is called Full Transportable Export/Import. It combines the basics of transportable tablespaces – of course cross-platform, cross-endianess, cross-version – with Data Pump taking care on all the stuff not stored in tables and indexes, such as views, synonyms, trigger, packages etc. And you can even reduce downtime by combining the feature with incrementally converted RMAN backups.

And the best thing: this will work with an Oracle Database 11.2.0.3/4 to Oracle Database 12c – so you don’t have to be on Oracle Database 12c in order to …

Continue reading...