Hi ,
I need to write a Unix shell which completes the below steps.
- 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)
- Place the files under respective client_name folder location and it shouldn't replace last week's old file .
- Once file is copied , this latest dump needs to imported automatically in Oracle database.
- Drop the existing user.
- 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.
- 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 recuiterMember since Mar 14, 2020 Medussa Multi B
from Departamento de Santander, Colombia