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!

schema integrity verification

Discussion in 'Server Administration and Options' started by acheo, Apr 22, 2015.

  1. acheo

    acheo Active Member

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

    I'm new with Oracle. Our Customer tests the application locally before deploying it on the server. Sometimes, he forgets to apply the sql scripts we gave him and errors are poping once on the server.

    What do you use to check the integrity of a schema usually? I would like to have a script that check if the schema is right and if not, apply the proper transformations.

    regards,

    acheo
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Define 'right'. You don't generate logs of the work these scripts do? You should, and then you could check for the existence of the logs then check them for errors.