Lisa Ashley Rafter
Member
Hi all,
I was wondering if when doing a schema comparison, PL/SQL developer or Oracle recompiles the objects prior to doing the compare?
The reason I'm asking is because I did a schema compare yesterday and there were a large number of invalid objects that suddenly became valid after the compare was done.
Is there a flag you can set in Oracle or Pl/SQL Developer to not compile invalid objects prior to doing the compare?
Thanks,
Lisa
I was wondering if when doing a schema comparison, PL/SQL developer or Oracle recompiles the objects prior to doing the compare?
The reason I'm asking is because I did a schema compare yesterday and there were a large number of invalid objects that suddenly became valid after the compare was done.
Is there a flag you can set in Oracle or Pl/SQL Developer to not compile invalid objects prior to doing the compare?
Thanks,
Lisa