Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.1.7 problem creating simple materialized view

Re: Oracle 8.1.7 problem creating simple materialized view

From: Jack <amitkr.3_at_gmail.com>
Date: 7 Mar 2006 07:16:28 -0800
Message-ID: <1141744588.624789.295370@j33g2000cwa.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US