Hi everybody,
the query below is runing well with a SQL*PLUS (database is mounted and not open)
SQL> SELECT member FROM v$logfile;
MEMBER
--------------------------------------------------------------------------------
+DATA/testgfi/onlinelog/group_1.298.773871647
+DATA/testgfi/onlinelog/group_2.294.773871647
+DATA/testgfi/onlinelog/group_3.295.773871647
But Giving error if I run it from Shell script ???
$ sqlplus -s '/ as sysdba' << EOF
SELECT member FROM v$logfile;
EOF
SELECT member FROM v
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only..
Please help..
Thanks..
Aljaro