I need a suggestion.
The scenario is: I've to execute 20K ORA scripts via the SQLPLUS command window method in one Database.
Those scripts from IH DB.So,we are copying the contents from IH to HOSTE
THE Hosted DB version is very far behind from the IH DB.
I'm splitting into 5k scripts in a folder (5k * 4 = 20k), will generate a log file after 1 * 5k folder scripts executed. This is a long way.
Do suggest easy, unique & timeless consumption to execute 20K Oracle scripts.
Note: After execution, I've to report script errors to the manager if Q flushes stuck & then proceed further.