We have one requirement that export data from two different source Oracle DBs and restore the data to another two different target Oracle DBs to do data comparison. We care about the datafiles in these two source Oracle DBs.
The Oracle db are 11.2 RAC. Can we use Oracle data dump tools such like impdp and expdp to meet the above requirement? Or is there any limitation to use data dump tools for the above requirement?
Thanks a lot.