Hello,

I noticed the following thing :

I have a shell script in which a sql order is executed :
*********************************************************
export ORACLE_SID=$1
$ORACLE_HOME/bin/sqlplus /nolog << EOF
connect / as sysdba
spool sqltest.lst
select * from sys.v$log;
spool off
EOF

The resultat is the following :
**********************************
(c) Copyright 2000 Oracle Corporation. All rights reserved.

SQL> Connected.
SQL> SQL> select * from sys.v
*
ERROR at line 1:
ORA-00942: table or view does not exist


Doing the same thing with a non v$* views, the result is OK.
(for v$*, I have to put the select order in a sql script and call it from the shell).

Do you have an explanation of this behavior ?

Thanks a lot ...