Hi!
Just for the record, one other solution would probably have been to set
REMOTE_DEPENDENCIES_MODE = SIGNATURE.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, October 25, 2003 10:24 PM
> Thanks Jared.
>
> Recently we did ru
Thanks Pete, that was the one.
Jared
On Sat, 2003-10-25 at 15:09, Pete Finnigan wrote:
> >
> >There's another script for this as well, but I can't recall
> >it at the moment. The above script is generally used as
> >a final step in an upgrade.
> >
> >Jared
>
> Hi Jared,
>
> Did you mean:
>
>
>
>There's another script for this as well, but I can't recall
>it at the moment. The above script is generally used as
>a final step in an upgrade.
>
>Jared
Hi Jared,
Did you mean:
utlirp.sql - UTiLity script to Invalidate & Recompile Pl/sql modules
Which does the extra invalidate first that
Thanks Jared.
Recently we did run catrepr.sql and catrep.sql to recreate replication catalog.
I was getting the same error even after recompiled all the invalid objects(few
packages were invalid). Then restared my instance and now it is woking fine.
Thanks again
-tamizh
- Original Message
Have you recently made any changes to your database?
Upgrades, etc?
This is the message you will receive when the state
of a package is invalid. It either needs recompiled,
as something it is dependent on has changed, and/or
it is broken for the same reason.
One possible explanation for this is
Hi List,
Coudl someone please help me out to resolve this issue?
1 begin
2* dbms_repcat.do_deferred_repcat_admin('scott_mg',FALSE);
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04062: of has been changed
ORA-04062: timestamp of package "SYS