INVALID NESTED VIEWS ORA-00903: invalid table name

SQL runs fine on 9.1 but on 9.2.1.0 I receive oracle error stating invalid table name.

1. Extracting the data directly from the view:

select * from customView; (No Problems)

2) Create a view which pulls from the

Create newView as select * from customView;

3) select * from newView;

ORA-00903: invalid table name

Any ideas what could be causing this?

Anyone seen this before?

Thanks in Advance. Received on Fri Feb 14 2003 - 14:26:22 CST