Virtual Classroom #13: Data Pump Extreme - Deep Dive with Development

[@upgradenow]

You find the slides here: apex.oracle.com/pls/apex/f?p=202202:2:::::P2_SUCHWORT:VC13DataPump And the Q&A: apex.oracle.com/pls/apex/f?p=202202:2:::::P2_SUCHWORT:VC13DataPump_QA

[@fancystacy]

Mike Dietrich is the best! I love him so much! 💕

[@upgradenow]

Hi Stacy, We love him too. Regards, Daniel

[@jeanj1354]

Very informative! Data Pump is a great tool widely used in oracle. It's very convenient for schemas et databases refresh from one environment to another. Thanks for putting all this together.

[@upgradenow]

Hi Jean, Thanks for the positive feedback on Data Pump and our webinar. Our webinar was a great success, so we are thinking about making a new one about Data Pump. If we do, any subjects that you would like us to cover? Regards, Daniel

[@abhishekkhanna66]

Great webinar

[@upgradenow]

Thanks! We're glad you liked it.

[@drbiswal]

Great Webinar with a lots of information. DPBP is a great bundle patch but the problem with this is non-RAC Rolling Installable and non-Data Guard Standby-First Installable. As the DPLoad patch link removed and recommended by Oracle to use DPBP from 19.12, Is there any alternative please ?

[@wbeaureg]

Hello, Dipti. The Oracle Data Pump Bundle Patch (DPBP) can be installed with Oracle Database running as long as Oracle Data Pump isn't running while the DPBP is being applied. This is mentioned in the My Oracle Support note: Data Pump Recommended Proactive Patches For 19.10 and Above (Doc ID 2819284.1). In case it isn't clear from the video, we decided to include the DPload patches in the DPBP because all of the patches are equally important. Best Regards, Bill Beauregard, Senior Principal Product Manager, Oracle Database Utilities Oracle America, Inc., :

[@upgradenow]

Hi Dipti, Currently, the Data Pump bundle patches are always non-RAC rolling and non-standby-first installable. You need an outage to apply them. We are working on improving this. I can't give a timeline, sorry. Regards, Daniel

[@taoqirhassan]

When we are migrating database from big endian to little by using DP queries execution plan chaanges qe can export query execution plan by SPM, on the source database it works on single query then another, is therr any method which will export all execution plans from AWR based queries, because se rime queries changes on EOM, EOY

[@upgradenow]

Check our "Performance Stability Prescription": kzbin.info/www/bejne/p3TXYpJ8mJh9iNU Regards, Daniel

[@taoqirhassan]

on which criteria data pump exports tables? based on tables name asc or des, or tables size?

[@upgradenow]

It depends, but generally large tables should get started first.

[@taoqirhassan]

@@upgradenow Thanks for your response , I have checked but this this is not always true

[@fancystacy]

You may create criteria for selecting segments by setting filters in your DP task. Also you can't influence the order in which they are exported or imported and there is no actually any reason to change that order, I would highly advise to wait antil import is finished before working with any of imported tables.

[@taoqirhassan]

As we know we can't start expdp in physical standby database (other than we in snapshot) due to master table creation, is there any mechanism we can skip master table? and redirect master table content to log file

[@upgradenow]

Hi Taoqir, No, it is not possible to use Data Pump without a control table. If you want to export from a standby database, it must be converted to a snapshot standby and opened read/write. Regards, Daniel

[@fancystacy]

The architecture of DP doesn't allow to export directly from readonly base. ^_^ BUT if you don't want to convert to snapshot standby you may license active standby, open it for read only and connect to it through link from primary or any other db, in that way master table would be created in read-write opened base. There is document written for you Doc ID 1356592.1

[@taoqirhassan]

Thanks ​@@fancystacy , With the network link we can't use parallelism