Today it is possible to have a PDB remote clone with:
CREATE PLUGGABLE DATABASE local FROM remote@remote_link;
However, most of the time these are clones from production to dev.
Some environments do not allow such db links DEV->PROD but would allow rather the opposite.
Workarounds exist, but they all require additional work:
- Connection manager setups
- SSH tunnels...
My proposal is to allow remote "push" cloning as well:
CREATE PLUGGABLE DATABASE remote@remote_link FROM local;