Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ora-942, why?
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