In 12c, we can have refreshable PDB from one PDB to another PDB via database link.
-Manual Refresh
CREATE PLUGGABLE DATABASE pdb_ref FROM pdb1@pdb_link REFRESH MODE MANUAL;
— Automatically refresh ever 60 minutes.
CREATE PLUGGABLE DATABASE pdb_ref FROM pdb1@pdb_link REFRESH MODE EVERY 60 MINUTES;
In 18c, this is extended and we can switchover the primary […]