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 [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).
RE: strange problem with v$recover_file ???
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 -- ONLINE6 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).
strange problem with v$recover_file ???
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).