Re: Exporting problem

From: John Harris <John.Harris_at_nurs.utah.edu>
Date: Tue, 19 Mar 2002 15:15:34 -0700
Message-ID: <a78g2a$poa$1_at_coward.ks.cc.utah.edu>


Thanks,

[Quoted] SYS.DBMS_REFRESH_EXP_LWM won't compile. The error message is:

Line # = 26 Column # = 7 Error Text = PLS-00904: insufficient privilege to [Quoted] access object DEF$_PUSHED_TRANSACTIONS
[Quoted] Line # = 26 Column # = 7 Error Text = PL/SQL: SQL Statement ignored Line # = 33 Column # = 9 Error Text = PLS-00904: insufficient privilege to access object DEF$_PUSHED_TRANSACTIONS
Line # = 33 Column # = 9 Error Text = PL/SQL: SQL Statement ignored

I'm connected as sys, so I'm not sure where to go from here.

John

"Hans de Ruiter" <hans.ruiter-de_at_siemens.nl> wrote in message news:a770g3$ea1_at_thor.siemens.nl...
> John;
>
> Yes looks like it. First make sure all packages are valid.
> Correct this problem and try it again.
>
> Regards
> Hans
>
> "John Harris" <John.Harris_at_nurs.utah.edu> wrote in message
> news:a75c17$3oo$1_at_coward.ks.cc.utah.edu...
> > I'm trying to do a user mode export, however it terminates 'successfully
> > with warnings'. Is there something I need to look for in the packages
> named
> > in the error messages? Below is the error output.
> >
> > Thanks.
> > John Harris
> >
> ...
> > ORA-04068: existing state of packages has been discarded
> >
> > ORA-04063: package body "SYS.DBMS_REFRESH_EXP_LWM" has errors
> >
>
>
>
Received on Tue Mar 19 2002 - 23:15:34 CET

Original text of this message