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 ...