Re: 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

Your problem is not reproducible with the information you gave: Step 2   ( Create newView as select * from customView; ) is an invalid SQL command, either it should read "create table newView" or "create view newView"

Rene Nyffenegger

-- 
  no sig today