Unix administrator / DBA to write a shell script for automating oracle import

Hi ,

I need to write a Unix shell which completes the below steps.

1. Need to connect source ftp server , grep the latest file and copy the dumps from source to local target server (have keyless ssh entry already)
   
2. Place the files under respective client_name folder location and it shouldnt replace last weeks old file .
   
3. Once file is copied , this latest dump needs to imported automatically in Oracle database.
   
4. Drop the existing user.
   
5. Create a new user with default_tablespace (I have an existing script to do this already)
   import the dump to newly created schema and while doing import I should be able to remap_schema and remap_tablespace.
   
6. Once import is completed we need to execute a set of scripts and export the schema as a clean dump from the database.

Note : I have an existing script already for the scenario , we need to fine tune it for full automation.

Also, I have some 15 clients and I need a generic script to do this job using client name and schema name. Based on the client name it should automatically grep the name and import as relevant schema in database and need to export.
About the recuiter
Member since Mar 14, 2020
Medussa Multi B
from Departamento de Santander, Colombia

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions