Hi All,
Please note, this is related to preparing the shell script for migration in Oracle EBS R12.2.3. Please let me know if I raised in wrong category.
As part of requirement we created 5 views, 3 packages, 1 custom table and 2 concurrent Programs. Now, we want to migrate all these using shell script. We are aware of migrating Concurrent Program using shell script. But we are not able to figure out how to run the .sql files(Which holds the create table, create views, create package) from .sh file. Because, in general, if we want to run any .sql file from PUTTY, we first connect to DB using syntax <sqlplus> and then DB credentials. Then, we will give the file execution command as <@file_name.sql> and once the file is executed, we will give <exit> to come out of db and then remaining process.
But, here we are facing issues writing commands in shell scripts for how to connect to db, how to run the .sql file and then how to exist .
Thanks in Advance,
Srivathsava