Re: Exporting problem

[Quoted] What kind of repercussions are there for re-running those scripts?

Thanks,

John
"Hans de Ruiter" <hans.ruiter-de_at_siemens.nl> wrote in message news:a7a2a0$4aj_at_thor.siemens.nl...
> John;
>
> Looks like a right's problem. SYS doesn't have rights to access the object
> mentioned below. It belongs tot SYSTEM. This brings up a next problem;
> normally they can be (and should be) accessed by SYS. At the creation of
> your database did you check your alert log for errors? Did all database
> creation scripts run? At the moment you can correct this problem by giving
> SYS object privileges to do a select on the table below. BUT this is just
> not the correct way. (Looks like some script didn't run) Check the alert
> log, and check (asuming 8i, if not something to this effect) that
> catalog.sql, catexp7.sql, catproc.sql,caths.sql and pupbld.sql has
> succesfully run, and check for any odd errors.
>
> Regards
> Hans
>
> "John Harris" <John.Harris_at_nurs.utah.edu> wrote in message
> news:a78g2a$poa$1_at_coward.ks.cc.utah.edu...
> > Thanks,
> >
> > SYS.DBMS_REFRESH_EXP_LWM won't compile. The error message is:
> >
> > Line # = 26 Column # = 7 Error Text = PLS-00904: insufficient privilege
to
> > access object DEF$_PUSHED_TRANSACTIONS
> > 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
>
>
>
Received on Thu Mar 21 2002 - 23:58:59 CET