Hi Champs,
Here is my requirement and need your guidance.
1) I have some bulk tables (200GB+) in production.
2) I have created a prod parallel schema in UAT, where we plan to dump required data from these bulk production tables (Not whole table dump) [based on conditions]
[based on conditions means will put filters as required by USERs for proper User acceptance testing]
3) I have used Oracle data_pump to export required data to binary dump (.dmp) files on production server. [successfully done this, no problems till here]
This is what i have done in Production DB and Production server so far.
UAT environment sits on different server, i need to sftp these dump files to UAT server and then will read these files from UAT server via external table and insert into designated tables.
External tables n all, no issues all good.
Issue - Since these .dmp binary files are server owned files. How can i sftp or transfer these files PROD server to UAT server so that external tables perform their operations.
It reflects with message "Permission Denied", Even while logged in as Superuser i can't give permissions. Files belong to oraibtcp user . Any Suggestions pls.