How to wrap import and export in a Unix shell script?
Hi all,
I want to write a simple korn shell Unix script to kick off export and import
for our Oracle 10g refresh databases. Do any of you have a script to do this?
The goal would be:
1. Take export using exp of 10 tables in PROD database on database server1
for the prod schema user
2. Use sftp or scp to copy over the export dump file to database server 2
3. Use a shell script to import the dump file into TEST database server for schema
test
4. use nohup to run the export and import in background through cron job
We are running Oracle 10g Release 2 on Red Hat Linux.
Thanks,
Ben Prusinski