DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Table/View comparison between schema

  1. #1
    Join Date
    Mar 2001
    Posts
    46

    Question

    I need to do a comparison between two schemas to determine if the records returned by the views/tables are identical. And if not to identify which views/tables are different.

    Does anyone have an SQL script/tool that will compare tables/views in different schemas? Or could you please explain how to access the views in different schemas.

    I have access to WinNT/Sun environments running Oracle8i.
    Thanks in advance!

  2. #2
    Join Date
    Oct 2000
    Posts
    90
    There is a free utility called T.O.A.D. which as a option to do this for you.

    The URL to get the free version is http://www.toadsoft.com/toadfree.zip

    It's fairly self explanatory, you have to log into one of the schemas and have a database link to the other, click refresh and it will show all the differences.

    Hope this is of help


  3. #3
    Join Date
    Mar 2001
    Posts
    46

    Toad is not quite what I'm looking for...

    M1l,
    Thanks for the quick reply. I've used the schema differences comparator in Toad. It's been a great help so far actually.

    Right now, I want to compare the actual records and not just the table/view definitions. Is there an option in TOAD to do this? I've only seen the comparison of the definitions and I have not seen a records comparator which is what I'm looking for.

  4. #4
    Join Date
    Jul 2000
    Posts
    243
    select *
    from a.table z
    where z.pk not in (select x.pk from b.table)

    it can take a lot of time, and if you need to do this on many table us it as a part of the procedur.

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    You say you have NT right? If so use OEM´s change management PACK I believe it also points out the difference between data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width