Sample Header Ad - 728x90

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