DB: Oracle 11g version 22.214.171.124.0
I am trying to clone a database on one environment (environment A) to another database on a separate environment (Environment B). Environment B's database is an out-of-date clone of Environment A's database. What would be the best methods for exporting the data from the database on environment A, and importing it to the database on environment B? I have tried using the export and import data pump to do this but it has been unsuccessful for importing the full database.
Also, we use Oracle Warehouse Builder to load data into the databases. When there are issues loading the data I currently restore a previous snapshot of the virtual machine prior to loading the data. Is there also a method to export the data prior to loading data, and then importing it again if there are issues when loading the data? Would export and import data pumps solve this issue?