impdp scripting

Hi All -

We are planning to use data pump to move some data periodically, based on some business requirements. I have done the proof of concept from the command line and it is working fine.

The next step is to have this automated via scripting. In our case we're doing an impdp and also using the network_link parameter. We have a few other parameters like remap_schema and remap_tablespace.

I'm trying to make this command into an executable script. Also, looking for best practice on how to handle the password.

I don't have much experience with scripting. Any suggestions are appreciated to get us started.