Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Executing multiple SQL scripts in a batch

780914Jan 24 2011 — edited Jan 24 2011
Hi All,

I need your help in executing multiple scripts together. I found several discussions but could not find an appropriate one.

I have around hundred(s) of SQL scripts in Development database. These scripts are meant to create whole schema (including table, db objects, DBA scripts and all). Now I have to install or create same schema in other global databases. For example

CRT_TAB1.SQL
CRT_TAB2.SQL
...
...
CRT_TAB98.SQL
CRT_PROC1.SQL
...
...
CRT_PROC30.SQL
CRT_PKG_SPEC1.SQL
CRT_PKS_BODY1.SQL
...
...and so on

One option is to create a master script and include all the scripts, which is quite tedious.
Is there any other way to create Scripts Package or Batch file or something, which can be handly in executing all the scripts in other databases.

I searched a few like Script Manager in TOAD, but don't have much hands on on it. Request you to please suggest a solution on this.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2011
Added on Jan 24 2011
4 comments
2,072 views