Data Compare gets stuck: Retrieving schema

Compares and synchronizes Oracle data

Data Compare gets stuck: Retrieving schema

Postby jacekglen » Tue Mar 13, 2012 11:15 am


Recently we've bought Oracle suite and I need to report a problem with that.

Firstly our setup: we have three databases: DEV, TEST and PROD. Each database has two schemas Profit and JDE. Whilst Profit schema is fairly simple (~20 tables, some views), JDE schema is quite complex. It consists of over 2500 tables, plus a number of views, packages and other objects.
Data Compare:
Database: Oracle 9i

We use Schema and Data Compare tools to synchronize the changes between the databases:

1) Schema Compare works very well and fast. No problems using it against either of the schemas. We tested both 32 and 64 bit versions.

2) Data Compare works well against Profit schema, but it's useless for JDE (the one with over 2k tables). I start a new project, set up data sources, and when I switch to Tables tab it starts retrieving schemas. It gets to the message: "Retrieving schema. Registering database one 50%" and then hangs up. I made several attempts, each time waiting at least 2 hours before giving up: there was no progress.

I hope you might look into this issue and let me know if it something you can fix.


Posts: 1
Joined: Tue Mar 13, 2012 11:06 am

Postby Tom Harris » Tue Mar 27, 2012 1:24 pm

Hi Jacek,

I have emailed you directly to try and capture some more information about what could be going wrong.

Kind regards, Tom

Tom Harris
Red Gate
Tom Harris
Posts: 308
Joined: Wed Oct 06, 2004 2:45 pm

Return to Data Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests