Hi ,
ONLINE is a reserved word. It should not be used as a column name. I
think it is bug.
rukmini
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 28, 2001 3:51 AM
> 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
>
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with Yahoo! Messenger
> http://phonecard.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Andrea Oracle
> 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rukmini Devi
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).