Discussions
Backing up SYSTEM.SCHEMA_VERSION_REGISTRY$
http/docs.oracle.com/cd/E23943_01/doc.1111/e16793/patch_set_installer.htm#CHDBEJIH
As per link above, what is the strategy to take backup of the SYSTEM.SCHEMA_VERSION_REGISTRY$ along with _MDS and _BIPLATFORM schemas?
How do I restore the SYSTEM.SCHEMA_VERSION_REGISTRY$ table back?
I have been using expdp and impdp to take export of _MDS and _BIPLATFORM but impdp does not restore SYSTEM.SCHEMA_VERSION_REGISTRY$.
expdp \"sys/sys@orbolap1 as sysdba\" schemas=prod_biplatform directory=DATA_PUMP_DIR dumpfile=prod_biplatform.dmp logfile=prod_biplatform.log
expdp \"sys/sys@orbolap1 as sysdba\" schemas=prod_mds directory=DATA_PUMP_DIR dumpfile=prod_mds.dmp logfile=prod_mds.log
0