need script to export file to remote server

AIX 5.3 DB 10.2.0.4

My requirement is to create a script that does export a bi开发者_开发百科g table from source to remote destination server and on remote destination database server to create another script that import that export table. In export script I need to add to purge exported data and it schedule on weekly basis.

Thanks,

There's a lot to this question. I would recommend you break it down and investigate how to accomplish each piece. For example:

• Copy files between computers: see scp
• Execute tasks on remote server: see ssh
• Schedule on weekly basis: see cron

Your question may be better served on ServerFault, as well.