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.

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