I am having a ploblem -- an error (ORA-00904: --Invalid Column..)when I query individual fields from a view [ i.e. "SELECT field1, field2,... FROM theviewname"]. However, the query runs as expected when I use the "SELECT * FROM theviewname". Could anyone tell me what might be the problem here, and any possible workaround to resolve this issue. The database server is an 8.17version.