1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Executing multiple SQL scripts in a batch

Discussion in 'Oracle' started by sbh, Jan 24, 2011.

  1. sbh

    sbh New Member

    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

    ...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.

Share This Page