1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Tool for executing oracle scripts

Discussion in 'General' started by sethumurugan, Nov 17, 2010.

  1. sethumurugan

    sethumurugan Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    Is there any tool which can be used to execute a oracle scripts in multiple schema.

    we are having nearly 75 schema and need to execute a script in all 75 schema. it is really time consuming job to do. there are possibility of lot of errors in this case.

    we have tried some batch mode concept. but we find some difficulties on this. am planning to create a application in VB which can do this job.

    but we wanted to check on the net before we do something on our own and we do not want to reinvent the wheel again.

    Thanks
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    What kind of script it is ? SQL or PL/SQL ?
    Give more details.
     
  3. sethumurugan

    sethumurugan Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    both scripts.

    The following are the list

    insert, update statements.
    procedure, functions and packs
    Triggers
    Table alter Statements


    Thanks
     
  4. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Why cant you

    1. Take a Export of the the data (table data, procedure , function , package etc)
    2. Import to different schemas by changing the touser parameter.

    It should work.
     
  5. janste

    janste Active Member

    Messages:
    23
    Likes Received:
    6
    Trophy Points:
    90
    Hi
    "dbWatch" is a database monitoring software that also gives you the option to run a script towards multiple target.
    Besides being a monitoring tool it also have allot of useful administration tools.