How to handle refreshing TEST schema with PRODUCTION schema ?

 

- we have database 10g ( standard edition), database name : ABC

- Schema name: ABC.PRODUCTION (which is our production schema)

- Schema name: ABC.TEST (which is our testing schema, where developers work)

Both the production & Test schemas exist in the same database.

Now once a week I wanted to refresh TEST schema with PRODUCTION data

Here is what I have been doing all these years:

=> Take a logical backup (EXPDP) of PRODUCTION schema (prod.dmp)

=> Drop user TEST cascade ( i don't need a backup of this TEST schema)

=> Create user TEST

=> Import PROD.DMP data into TEST schema

All the above 4 steps are being done manually.