Hi folks,

We have a production database on RAC Mode which has 4 node setup , we need to refresh two user or schema tables which around 200 tables from production to test database for examaple

Prod is Production database on 4 RAC node setup username are proddta, prodctl, both of them have around 200 tables i need to refresh test database with two users name testdta,testctl,
now my question is is there any way to refresh this through Enterprise Manager cloud control 12c or SQL developer or Toad?
please if so could you people tell me the way through snap shot or step by step prodecure

I would appreciate a lot for your suggestion


we don't have oracle user level access so there is no chance for Expdp/Impdp, or normal exp/imp


thanks & regards.