Re: Exporting problem

John;

[Quoted] 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 Wed Mar 20 2002 - 14:20:01 CET