Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.1.7 problem creating simple materialized view
Spendius wrote:
> Guess you have to run $ORACLE_HOME/rdbms/admin/catrep.sql
> first.
>
> Jack schreef:
> > ...
> > SELECT * FROM op_leave_thresholds_at_rmop
> > *
> > ERROR at line 3:
> > ORA-00942: table or view does not exist
> > ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 919
> > ORA-06512: at line 1
> >
> > Thanks
I already have working materialized views on the same database ..
Do you still insist on your solution...?
Thanks Received on Tue Mar 07 2006 - 09:16:28 CST