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!

Database difference script

Discussion in 'SQL PL/SQL' started by lucky, Jan 18, 2010.

  1. lucky

    lucky Active Member

    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    80
    Hi All,

    we have two database( testing and development), i want to find out the difference b/w those two databases at object level like tables, index packagess, procedure etc
    and is it also possible to find out the difference (definition and specification) of packages/functions/procedures i mean to say the code difference.

    if possible, pl help me the scripts.

    Thanks in advance.
    Lucky.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    TOAD can produce such a report. Also the information is available in views such as DBA_OBJECTS, DBA_SOURCE, DBA_TABLES, DBA_INDEXES, DBA_TAB_COLUMNS, DBA_VIEWS, DBA_UPDATABLE_COLUMNS, DBA_MVIEWS and others. A dblink from development to test with the proper privilges along with knowledge of the above views should allow you to write such a script. And the web is a great source to utilize; google is your friend. As a starting point:

    http://www.lmgtfy.com/?q=oracle+database+comparison+scripts
     
  3. lucky

    lucky Active Member

    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    80
    Hi All,

    Thank you very much for the quick response.