Disable All Foreign Keys in Oracle Scheme

Bnt456 · March 16, 2017 2:17AM

Hi,

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

Eddie D · March 20, 2017 7:00AM

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

Bnt456 · April 3, 2017 3:54PM

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.

Eddie D · April 3, 2017 3:56PM

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

Disable All Foreign Keys in Oracle Scheme

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk