Activity overview
Latest activity by Adam.M
Chris Auckland wrote:
Thanks for your post.
I'm interested to know how the recomplile is invalidating other objects in your database. Is that just during the recompile, or is it breaking them completely in some way?
Hi Chris,
It's just the re-compile causing the invalidation of other objects that are dependent on the object being compiled.
We're in a position where we cannot use the deployment scripts created by Schema Compare (at least without tweaking them) for promoting changes to our live environment as we know these compile statements will invalidate other packages.
It would be really useful to have an option to turn these statements off.
And another nice feature would be the option to have the script perform a compile of any invalid objects in the schema at the end. / comments
Chris Auckland wrote:
Thanks for your post.
I'm interested to know how the recomplile is invalidating other objects in your database. Is that just during the recompile, or is it breaking them co...
Redundant ALTER PACKAGE COMPILE statements in deployment?
Hi.
We have found that when using the Deployment Wizard in Schema Compare for Oracle that our scripts containing package body changes are prefixed with ALTER PACKAGE COMPILE statements.
For example...
Case sensitivity between machines
I've just spoken to Ben on the phone and he said that I should raise this bug report in the forum.
We have an Oracle 10g database with a number of schemas where development is shared between more t...