Oracle Database Discussions

Question

I have a situation where I would like to use Data Pump to refresh a test database schema weekly from our production instance schema. I would like to set up a job to do this with data pump. I can use data pump (impdp) with success using the network_link with no issue. My question is does anyone know if there is a way (or can recommend a way) to update all schema objects in this refresh job? For example, I want to bring over all tables, data, sequences, plsql, etc. The impdp command allows for TABLE_EXISTS_ACTION=REPLACE to replace existing tables/data, is there a similar commadn so I can do this for specifically sequences, etc? Is there a replace command for other objects types when using impdp? If not anyone have any ideas how I can easily do this?

I know I could write a sql script to drop and recreate all, but then I run into the problem of having to regrant privileges to sequences, synonyms, plsql, etc.

Looking for ideas.

Thanks.