Oracle 8.1.7 problem creating simple materialized view

Hi,
I am trying to create a simple snapshot on my database using the following:

CREATE SNAPSHOT thresholds_ak
as
SELECT * FROM thresholds_ak_at_ak_test;

Its giving me folllowing errors.

ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 919
ORA-06512: at line 1

A simple select
select * from thresholds_ak_at_ak_test
works as expected.

Any help will be greatly appreciated.

Thanks Received on Tue Mar 07 2006 - 08:48:26 CST