Hi,

I am getting strange errors while accessing the V$ views each time I access them throws me some or the other error why Oracle behaves like this?

Oracle: 9.2.0.7
Unxi :Aix5.2

SQL> select name from v$tempfile;
select name from v$tempfile
*
ERROR at line 1:
ORA-00911: invalid character


SQL> select Name from v$tempfile;

NAME
--------------------------------------------------------------------------------
/u07/oradata/sreport/wsadatatemp02.dbf
/u06/oradata/srep/wsadatemp01.dbf
/u10/oradata/sreport/wsadatatemp03.dbf.dbf

SQL> select name from v$tempfile;
select name from v$tempfile
*
ERROR at line 1:
ORA-00911: invalid character


DBAs> select any_idea " why it throws me error " from dba_support.com;

no rows selected