From rukmini@indbrain.com Mon, 27 Aug 2001 23:01:15 -0700 From: "Rukmini Devi" Date: Mon, 27 Aug 2001 23:01:15 -0700 Subject: Re: strange problem with v$recover_file ??? Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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" 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@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@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@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@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).