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: ora-942, why?

Re: ora-942, why?

From: Michael Abbey <msabbey_at_magi.com>
Date: 1996/11/01
Message-ID: <327A1D60.2896@magi.com>#1/1

Chuck Hamilton wrote:
>
> What's wrong with the following statement? I get an ORA-942 (table or
> view does not exist) on the subquery on the last line.
>
> I can describe the table, select * from the table, and have verified
> that it is indeed a table not a view. I've also verified that there is
> no other object in the user's schema named 'drug'.
>
> The user trying to create this snapshot has DBA privilege.
>
> Is there something simple that I'm not seeing?
>
> create snapshot drug
> tablespace mhp
> pctfree 0 pctused 90
> storage (initial 9379840 next 1m pctincrease 0)
> unrecoverable
> using index
> tablespace mhpx
> pctfree 10
> storage (initial 5181440 next 1m pctincrease 0)
> refresh fast start with sysdate next trunc(sysdate+1)
> as select * from mhp.drug
> /
> ERROR at line 11:
> ORA-00942: table or view does not exist

Perhaps someone should run CATSNAP.sql as there may be an object missing in the SYS schema to support snapshots.

Michael

###################################################################
# Michael Abbey           Ottawa ON Canada      613 780 2364
#
# Co-author of:   Tuning Oracle          Oracle: A Beginner's Guide
#                 Oracle Data Warehousing
###################################################################
Received on Fri Nov 01 1996 - 00:00:00 CST

Original text of this message

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