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
> --
> Chuck Hamilton
> chuckh_at_dvol.com
>
> This message delivered by electronic sled dogs. WOOF!

Maybe the user creating this snapshot has a select privilege on mhp.drug through a role. You say this user has DBA privileges, so he has the role 'select any table'.The user creating this snapshot should have this privilege directly and not trough a role.

P.W. Milo
ORCA Solution BV Received on Mon Nov 04 1996 - 00:00:00 CST