Exclude tables while cloning from prod

[kumaran]

Hi Experts,

I want to know the possible ways to exclude certain tables while cloning production data to DEV or TEST.

Few tables have sensitive information and we dont want those tables to be cloned to DEV..

While going through wiki I understood that we have to use 'preserve data' and 'Exclude tables' module and define my tables.

but do it need to define this tables in Prod or dev?

Please help me if anyone used anyother successfull approaches.

Thanks in Advance.

[rohanhd]

Hi Sergiu,

My issue is I don't want data in my dev environment to be overwritten at the same time I don't want data from prod.

So should I defined data preservers & exclusion on source or should we do in target because wiki says source?

[sergiu_panaite]

This has to be defined for the target instance, have a look here:

System clone

Data preservation on cloning target instances