User profile for Alice E

Hi, If you turn on the "Force column order" option (it lives on the Options tab of the connections dialog), Schema Compare for Oracle will rebuild the table and take care of the data in the way you described. If the "Force column order" option is not enabled, the column will just be added to the table, without a rebuild. Hope this helps, Alice. / comments

Hi, If you turn on the "Force column order" option (it lives on the Options tab of the connections dialog), Schema Compare for Oracle will rebuild the table and take care of the data in the way you...

0 votes

We've tracked this down to an error registering the WMSYS schema which we've fixed in the latest build (1.0.0.681). Can you give this new build a try and let us know if it fixes the problem? Thanks, Alice. / comments

We've tracked this down to an error registering the WMSYS schema which we've fixed in the latest build (1.0.0.681). Can you give this new build a try and let us know if it fixes the problem? Thanks...

0 votes

We've just released our new early access build. We've made a lot of improvements around dependencies and general stability, and would hugely appreciate it if you could give it a try and let us know if it resolves your issues. You can download the new build here. Thanks, Alice. / comments

We've just released our new early access build. We've made a lot of improvements around dependencies and general stability, and would hugely appreciate it if you could give it a try and let us know...

0 votes

Thanks for sending the logs across. We've identified the issue as being a problem with the way we're handling PL/SQL objects in dependent schemas not included for comparison. We've got a fix for this that will be in the next EAP build (unfortunately we don't have any timescales for that yet). In the meantime, a workaround would be to make sure your comparison includes all the schemas that are referenced by the objects you want to compare (so, if you're comparing a table in SchemaA that references a procedure in SchemaB, make sure you include SchemaB for comparison). Hopefully that should fix the problem - please let us know if it doesn't or if you have any other feedback for us. Thanks, Alice. / comments

Thanks for sending the logs across. We've identified the issue as being a problem with the way we're handling PL/SQL objects in dependent schemas not included for comparison. We've got a fix for th...

0 votes

To help us track down what's going on, can you turn on logging and send us the log file? This help file explains how to turn on logging: http://www.red-gate.com/supportcenter/C ... ta_Compare\knowledgebase\logging_and_log_files.htm If you send the log to me at alice.easey@red-gate.com, that'd be great. Thanks, Alice. / comments

To help us track down what's going on, can you turn on logging and send us the log file? This help file explains how to turn on logging:http://www.red-gate.com/supportcenter/C ... ta_Compare\knowle...

0 votes

Hello, Thanks for your post. We've just released a new build that includes a 'direct connection' option that connects via TCP/IP instead of through the Oracle client. The option is in the Application Options, called "Use direct connection". Can you give it a try and let us know if it helps with the ORA-03113? Thanks, Alice. / comments

Hello, Thanks for your post. We've just released a new build that includes a 'direct connection' option that connects via TCP/IP instead of through the Oracle client. The option is in the Applicati...

0 votes

Hi Max, We're hoping to release a new build with an Ignore Whitespace project option very soon. Are there any other project options you'd find useful? Thanks, Alice. / comments

Hi Max, We're hoping to release a new build with an Ignore Whitespace project option very soon. Are there any other project options you'd find useful? Thanks, Alice.

0 votes

If you can email me at alice.easey@red-gate.com, I'll add you to the list of people interested in this feature. I'm afraid we don't have any definite timescales yet, but we'll keep you posted with any developments in this area. / comments

If you can email me at alice.easey@red-gate.com, I'll add you to the list of people interested in this feature. I'm afraid we don't have any definite timescales yet, but we'll keep you posted with ...

0 votes

Hi Max, Thanks for your post. Our current plan is to only support 10g and 11g for v1 of Schema Compare for Oracle. We're intending to add support for 9i in a later release, depending on the popularity of the request. Can I ask what your current setup is? Do you use exclusively 9i databases, or do you have a mix of other versions? Thanks, Alice. / comments

Hi Max, Thanks for your post. Our current plan is to only support 10g and 11g for v1 of Schema Compare for Oracle. We're intending to add support for 9i in a later release, depending on the popular...

0 votes

OK. Thanks for all your feedback so far, we really appreciate it! / comments

OK. Thanks for all your feedback so far, we really appreciate it!

0 votes

How can we help you today?

Alice E

Comments