We have PROD and TEST Oracle Servers running on the same HP-UX 11.0 box. We have to refresh the TEST database with PROD data. What is the easiest way of doing it?
We have done a complete export of PROD database. However, since TEST is also on the same box and using different datafiles are there any issues with importing the same? Also, any issues with Database Name in doing import?
Any help in this matter is highly appreciated.