What are the challenges you face when working across database platforms? Take the survey
Options

Disable All Foreign Keys in Oracle Scheme

Bnt456Bnt456 Posts: 3
edited March 20, 2017 7:00AM in Data Compare for Oracle
Hi,

While Comparing Data using Redgate Data Compare do we need to Disable all the Foreign Keys ?

Comments

  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    Hi, thank you for your support request.

    To perform a comparison using Data Compare for Oracle, there is no need to disable all the Foreign Keys.

    Are you encountering any errors or problems using Data Compare for Oracle?

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options

    Hi Eddie,

    Thanks for the reply.

    I am trying to compare records using Data compare for oracle.

    the tool is comparing records in 6 table only.

    While for other table(1009 tables) it is saying table could not be compared.

    Can you please explain.

  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5

    Hi, thank you for your reply.

    I suspect that 1009 tables do not have an automatic comparison key.

    For Data Compare for Oracle (DCO) to be able to compare the rows of data held in the tables, it needs a comparison key for each table. DCO automatically selects a comparison key when the tables contain a matching primary key, unique index or unique constraint.

    If DCO cannot identify a suitable key, the table is not compared. However the using can set a custom comparison key by editing the project ->Selecting the tables & views tab ->Manually set a custom comparison key. This help article explains:
    http://documentation.red-gate.com/displ ... to+compare

    Hopefully the above answers your question.

    Many Thanks
    Eddie

    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.