I have a materialized view that uses a sequence. It works fine on Sparc Oracle 8.1.5.0.3, but it doesn't work on NT Oracle 8.1.6.0.0.

--Code example
create sequence seq1;

create materialized view table_id as
select table_name, seq1.nextval AN_ID from user_tables;

On NT I get the error msg:
ORA-02287: sequence number not allowed here

I was told that there was a special notation for sequences on NT, but I cannot find any information on it.

Note: A view with a sequence works fine.i.e.
--code example
create sequence seq1;
select table_name, seq1.nextval AN_ID from user_tables;

Any suggestions, work arounds?