ora-942, why?

From: Chuck Hamilton <chuckh_at_dvol.com>
Date: 1996/11/01
Message-ID: <327a0eba.6366960@n5.gbso.net>#1/1

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!

Received on Fri Nov 01 1996 - 00:00:00 CST