Red Gate forums :: View topic - Data Compare gets stuck: Retrieving schema
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Data Compare for Oracle
Data Compare for Oracle forum

Data Compare gets stuck: Retrieving schema

Search in Data Compare for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
jacekglen



Joined: 13 Mar 2012
Posts: 1

PostPosted: Tue Mar 13, 2012 12:15 pm    Post subject: Data Compare gets stuck: Retrieving schema Reply with quote

Hi,

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: 1.0.2.55
Database: Oracle 9i
ODAC: 11.2.0.3.0

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.

Regards,

Jacek
Back to top
View user's profile Send private message
Tom Harris



Joined: 06 Oct 2004
Posts: 308

PostPosted: Tue Mar 27, 2012 2:24 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group