Is it safe to sync Oracle 19c to 12c via dblink?
1
vote
0
answers
660
views
Source database: Oracle 19c
Target database: Oracle 12c, via dblink
Is it safe to sync tables from a higher version to a lower version?
1. I will create a materialized view on the target with scheduled refresh.
2. Then I will insert it to target tables.
Is this safe?
The reason for my question is that, when using datapump, based on my experience, when the source database is of a higher version than the target, I need to specify
[version=12.0.2.6]
in the .par
files when exporting from Oracle 19c to 12c.
Asked by Alex Borja
(11 rep)
Oct 1, 2022, 11:08 PM
Last activity: Oct 1, 2022, 11:34 PM
Last activity: Oct 1, 2022, 11:34 PM