Re: strange problem with v$recover_file ???

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" <ORACLE-L_at_fatcity.com> 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: andreaoracle_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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: rukmini_at_indbrain.com

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: ListGuru_at_fatcity.com (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).