Schema compare times out

Compares and synchronizes the schemas of Oracle databases

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

Schema compare times out

Postby gkaczor@e-point.pl » Wed Dec 11, 2013 1:17 pm

Hello,

I can open test connections to my databases but the comparison times out during the "Reading dependency information" phase ("Initializing database connection" lasts a minute or so, and then a "Network error" appears).

I suspect this may be due to long time needed to read ALL_OBJECTS table in the database and I would like do increase timeout.

How can I increase the timeout?

Thanks for any help.
Grzegorz
gkaczor@e-point.pl
 
Posts: 1
Joined: Wed Dec 11, 2013 1:09 pm

Postby eddie davis » Thu Dec 12, 2013 11:42 am

Hi,

Thank you for your forum post.

Can you please try adding the ConnectionTimeout = <value in seconds> to the connection string commands in the Server name box, for example:
Code: Select all
ServerName\\InstanceName;ConnectionTimeout=600

where the value 600 = 600 seconds


I see that you have also created Support Ticket #9534, any further problems please update this support call.
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to Schema Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests