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: Spendius <spendius_at_muchomail.com>
Date: 7 Mar 2006 07:12:00 -0800
Message-ID: <1141744320.871567.240390@u72g2000cwu.googlegroups.com> 





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

Received on Tue Mar 07 2006 - 09:12:00 CST












Original text of this message













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