asked on

Error in creating a materialized view (ora-00942)

I will like to create a materialized view on a schema tr which has select grant on a table cars on a different schema src
I used the following statement
CREATE MATERIALIZED VIEW tr.cars_mv
TABLESPACE xxxx
LOGGING
REFRESH FAST
WITH PRIMARY KEY
AS
SELECT
Name,
Type
FROM src.cars
;

I am having the following error:
ora-00942: table or view does not exist

I have done the following checks
•      the spelling of the table or view name.
•      that a view is not specified where a table is required.
•      that an existing table or view name exists.

In fact if I run the query under tr it functions that is without the create materialized view statement

What could be the source of the error. Could it be related to the characteristics of the materialized view ( REFRESH FAST ) to be created

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

diteps06

ASKER

I forgot to mention a detail the table cars have a materialized view log table created on it.
the schema tr doesn't yet have a grant select on it. Maybe this is cause of the error. I am still to verify it

SOLUTION

hinpong

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

slightwv (䄆 Netminder)

hinpong,

How is your post any different than what I have already posted?

Please read previous posts before responding.

slightwv (䄆 Netminder)

diteps06,

Mind if I ask why the "B" penalty grade? What additional assistance did you need before providing an "A" grade.