I have two databases, one is production and second is a test. I want to export from production database and import into test database. My production db contains many users/schema out of which only few (<10) schemas contain actual objects. First time, i did a successful full export and full import into my test system without any problem.
The idea is to do this on a periodic basis maybe once in couple of weeks. How can i do this process without creating a whole new test database again doing the re-import??