Andrea,
>From Metalink, the column is defined in uppercase:
SQL> select online from v$recover_file;
select online from v$recover_file
*
ERROR at line 1:
ORA-00936: missing expression
SQL> select "ONLINE" from v$recover_file;
no rows selected
Also, online is a reserved word and that is why you originally get the
ora-00936 error:
SQL> select * from v$reserved_words where keyword ='ONLINE';
KEYWORD LENGTH
---------------------------------------------------------------- ----------
ONLINE 6
SQL>
Regards,
Bruce Reardon.
-----Original Message-----
Sent: Tuesday, 28 August 2001 8:22
All, I got a problem with v$recover_file. Somehow the
query failed if selecting is on ONLINE column.
SQL> desc v$recover_file;
Name Null? Type
----------------------------- --------
---------------
FILE# NUMBER
ONLINE VARCHAR2(7)
ERROR VARCHAR2(18)
CHANGE# NUMBER
TIME DATE
These are OK:
-------------------
select CHANGE# from v$recover_file;
select TIME from v$recover_file;
select * from v$recover_file;
However these gave me error:
------------------------------------
select ONLINE from v$recover_file;
select online, ERROR from v$recover_file;
select FILE# , ONLINE,ERROR , CHANGE#,TIME from
v$recover_file;
*
ERROR at line 1:
ORA-00936: missing expression
SQL> select v.name, b.online
2 from v$datafile v, v$recover_file b
3 where v.file# = b.file#;
select v.name, b.online
*
ERROR at line 1:
ORA-01747: invalid user.table.column, table.column, or
column specification
What's happening?! Thank you.
Andrea
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).