I need to do periodic (every week) refresh of our TEST database with data from PROD database (Oracle 11.2 windows)
I've tested RMAN DUPLICATE command and I think that it will do what I need.
But I have one question regarding duplication process.
Is it possible to exclude specific table from duplication process? I know that I can skip tablespace, but not specific table.
I have different configuration and user accounts on test and production. Configuration table and user accounts table needs to be preserved on test database and must not be overwriten with production data.
Do you have some tips how to achieve this? (expdp old test tables -> RMAN DUPLICATE -> drop some tables and do impdp from previously exported dump?)
Production DB has 200GB so RMAN DUPLICATE from DB backup will be probably fastest way how to do the duplication.
Thanks for some tips