Refresh Table

[big]

Hi,

On 19c on AIX

We want to refresh just a table (in DEV) from the same table of PROD every week.

What are the possibilités?

What do you suggest?

Thanks.

[ErmanArslansOracleBlog]

Materialized view via DB link with MW logs enabled -- Refresh Groups
Export-import (expdp-impdp)
Using PLSQL and a dblink you can do it on your own.
You can also use a CDC application (Goldengate, Striim etc.)
You can also use a partition based exp-imp