Hello,
I have a requirement to create a config file and shell batch file, so the idea is when I run the batch file it should pickup the database connection details from the config file and should generate another batch file in this format sqlplus username/password@host:port/service @file location, so that when I run the generated batch files it will create, drop or truncate as needed. Please let me know if any of you have done this, the reason is we have to do this repeatedly on different schema's and db's and we are trying to minimize manual intervention. Also, there is more we have to build on top of this logic, but this will be a good start.
Thanks in advance.
Thanks,
Ravi