DB version: 19.11
My requirement:
I have a UAT Pluggable DB named PDB_UAT with some Oracle Advanced Queues (AQs) and propagations on a schema named Q00XYZ.
I will refresh this PDB using the production PDB equivalent (PDB_PROD) using RMAN duplicate from tape.
So, I want to Save AQ and Queue propagations on PDB_UAT before the refresh and then restore it back after the PDB refresh using RMAN Duplicate.
So, basically, I need to
1. Save the DDL of Sender and receiver AQs
2. Save the DDL of suscriber and propagation of the Sender queues
3. After the PDB cloning, purge the queue tables or drop all queues (restored from prod) altogether --- I already have the code for this
4. After the PDB cloning, recreate the queues, suscribers and the propagations using the saved DDL from PDB_UAT/Q00XYZ schema
Question1.
Can items 1 and 2 be done using expdp and item 4 using impdp ?
If items 1 and 2 ca be done using expdp, what should I specify for the INCLUDE clause in expdp ?
Question2. I came across the following stackoverflow post which says the following.
But, this is for version 11.2. Are things different on version 19c ?
"Export import of queues is now fully supported at queue table level granularity. The user only needs to export the queue table. All the queues in the queue table, primary object grants, related objects like views, IOTs, rules are automatically exported "
https://stackoverflow.com/questions/30607963/oracle-queue-is-not-been-imp-or-exp-in-oracle-11g
Question3. Or should I some other method (other than expdp/impdp) ? i.e, to save AQ and Queue propagations on PDB_UAT before the refresh and then restore it back after the PDB refresh ?