Re: Exporting problem
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