Hi,

I am using NT 4.0 (8i , Release 8.1.5.0.0 )/Window 95(SQL PLUS 8.0, Release 8.0.6.0.0 ) combination.
I tested you sentece but it is working fine.
What is the version of your SQL PLUS? Sometimes lower vesion of SQL Plus also create probem.

SQL> create sequence seq1;

Sequence created.

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

Snapshot created.

SQL> select * from table_id;

TABLE_NAME AN_ID
------------------------------ ---------
ACCOUNT 29
AUDIT_EMP 30
BONUS 31
BOOKS 32
CUST_MST 33
D2_T1 34
DEPARTMENT 35
DEPT 36
EMP 37
EMP2 38
EMPLOYEE 39
EMPVIEW 40
..
..
..



P. Soni


[Edited by PSoni on 03-15-2001 at 07:00 AM]