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 an incomplete
upgrade.
You can recompile all stored code in the database
by logging in as SYS and running $ORACLE_HOME/rdbms/admin/utlrp.sql.
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
On Sat, 2003-10-25 at 10:14, [EMAIL PROTECTED] wrote:
> 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.DBMS_REPCAT_RPC" has been changed
> ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 812
> ORA-06512: at "SYS.DBMS_REPCAT", line 532
> ORA-06512: at line 2
>
>
> -tamizh
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
